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.
Watch the recorded webinar!
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