tSingleStoreOutputBulk

Prepares the bulk file to be used as a parameter to feed the database connected.

The tSingleStoreOutputBulk and tSingleStoreBulkExec components are used together in a two step process. In the first step, a bulk file is generated. In the second step, the bulk file is used to feed the database connected. These two steps are fused together in the tSingleStoreOutputBulkExec component, detailed in a separate section. The advantage of using a two-step process is that the data can be transformed before it is loaded in the database.

tSingleStoreOutputBulk writes a file with columns based on the defined delimiter.