CODEWITHSUNDEEP
javasql-servertalend
Meen
Meen

Reputation: 119

Incremental mode in Talend

I have 2 tables in my database-: Office -
enter image description here

and office_import :
enter image description here

The office table is fed by office_import table using incremental mode based on the office_name.
The field END_date of Office table is currently NULL, but I need to check in the office_name from office table does not exist in the office_import table, then the END_date needs to be updated with the current date, otherwise it shall remain NULL only.
I have created the job as below but the job keeps on executing for more than 3 hours and then I gets the I/O Timeout error.
enter image description here
I have used the below script to feed the END_Date -
enter image description here

Please help.

Upvotes: 0

Views: 115

Answers (1)

Corentin
Corentin

Reputation: 2552

In tMap , you don't have any join key between tables row2 and row3 : you just have a cross join. Drag&drop "Office_name" from row2 onto row3.Import_office_name in order to get a proper left join. (you'll see the purple link between the two tables, indicating the join)

Upvotes: 1

Related Questions