Prepares the file to be used as parameter in the INSERT query to feed the Vertica database.
The tVerticaOutputBulk and tVerticaBulkExec components are generally used together as parts 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 tVerticaOutputBulkExec 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.
tVerticaBulkOutputExec writes a file with columns based on the defined delimiter and the Vertica standards.
For more technologies supported by Talend, see Talend components.