tPostgresPlusBulkExec

Improves performance during Insert operations to a DB2 database.

The tPostgresPlusBulkExec executes the Insert action on the data provided.

The tPostgresplusOutputBulk and tPostgresplusBulkExec components are generally used together as part of a two step process. In the first step, an output file is generated. In the second step, this file is used in the INSERT operation used to feed a database. These two steps are fused together in the tPostgresPlusOutputBulkExec component, detailed in a separate section. The advantage of using two separate components is that the data can be transformed before it is loaded in the database.