Using MySql Bulk Exec with column defaults

Anonymous — Thu, 10 Sep 2015 18:33:41 GMT

Hi
I plan to use the Bulk Exec task for MySql to load a data file into my staging tables for preprocessing. The stage table has a column which is company_connector_id that identifies the source of the data(this is an internal identifier). This column is obviously not available in the client data file coming in.
If i was to load this data file through the MySql command i would use the command

load data local infile 'filepath/filename' into table stg fields terminated by '|' lines terminated by '\r\n'
(column1, column2, column3....)
set company_connector_id = 1234

The value of the company connector id would get set.
How do i do this when i am using the tMySqlBulkExec task? I can pass it through a context but how can i set it through the task?

Re: Using MySql Bulk Exec with column defaults

Anonymous — Mon, 21 Sep 2015 01:04:52 GMT

Read the client data file and rewrite the file to add this column before loading it.
Best regards
Shong

topic Re: Using MySql Bulk Exec with column defaults in Talend Studio

Using MySql Bulk Exec with column defaults

Re: Using MySql Bulk Exec with column defaults