I have a job where the job reads data from excel sheet and insets data to a mysql table. Let's say that it inserted 25 rows in Table "A". In table "A", I have one column as 'run id' which inserts a unique uuid for every job run. So, for all the 25 rows it inserted in a single run the 'run id' column has the same uuid value. I wanted to insert a single row into another table- "Table B" where "run id" column acts as foreign key between "Table A" and "Table B". How do I insert a single row in "Table B" for every job run, while inserting 25 rows in "Table A"?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema