I'm relatively new to Talend and working with it for my master thesis. I'm struggling with a (imho) simple task which i may have a solution for but it doesn't seem pretty.
My problem: i'm extracting some data out of 2 tables from a database and then i need to pass this data to two following (parallel) flows. So i used the tReplicate component to duplicate the output. Now i need to perform the two following tasks in a specific order because the results won't be correct otherwise.
The output of the tReplicate is used to update some records in a database table AND to insert a few new records.
My solution would be to write the output that is replicated into a file and the read it twice. First when i want to update records and then again in order to insert new records. For the right order of execution i'd use the "on Subjob OK" events.
Is this the best solution or did i oversee a better way?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables