topic Difference between tMysqlBulkexec and tMysqlOutputBulkExec in Talend Studio

Difference between tMysqlBulkexec and tMysqlOutputBulkExec

Anonymous — Wed, 20 Sep 2017 11:02:22 GMT

Hi Team

Can you please explain what is the difference between

tMysqlBulkexec and tMysqlOutputBulkExec.

Thanks in Advance

Deepthi

Re: Difference between tMysqlBulkexec and tMysqlOutputBulkExec

Anonymous — Thu, 21 Sep 2017 04:10:10 GMT

Hello,

The tMysqlOutputBulk and tMysqlBulkExec components are used together in a two step process. In the first step, an output file is generated. In the second step, this file is used in the INSERT statement used to feed a database.

These two steps are fused together in the tMysqlOutputBulkExec component, detailed in a separate section. The advantage of using two separate steps is that the data can be transformed before it is loaded in the database.

Let us know if it is OK with you.

Best regards

Sabrina

Re: Difference between tMysqlBulkexec and tMysqlOutputBulkExec

Anonymous — Mon, 16 Oct 2017 03:07:25 GMT

Hello,

Feel free to let us know if it is OK with you and post your issue here.

Best regards

Sabrina