5ce1dc4e_ata_Integration___Pentaho_Wiki__Description
[Option] Use batch update for inserts [Description] 
Enable if you want to use batch inserts. This feature groups inserts statements to limit round trips to the database. This is the fastest option and is enabled by default. Note: There are limiting factors depending on the used database type and further step options. The batch mode is only used when this check box is selected and the Commit Size is greater than 0 and the Return auto-generated key option is not enabled and the transformation is not enabled to use unique connections (Transformation settings / Misc / Make the transformation transactional) and the following rule is false: the database type supports safe points and step error handling is enabled (see the database feature list to check if the database supports safe points) and the database type supports batch updates (see the database feature list to check this)
Table Output - Pentaho Data Integration - Pentaho Wiki