I need design one job that work in the follow way:
I have 2 table: tableA and TableB.
I have to join tableA,tableB with tMap. The result of that join are record that I would delete
It's possible? How I can do it?
thnx at all
Solved! Go to Solution.
You are looking to do this in a single job? You can do a second database connection using the output from the tMap to do the delete.
Just on the off chance that you are looking at the simplest base case: If the two tables are in the same database, you shouldn't need to use a tMap unless it is not just a lookup, but has some additional complex logic being applied. You could do that through a single SQL statement that you embed in a job.
take two flows in singale job.
1) do the join between Table A and Table B, and load to tHashoutput.
2) once the first flow commpleted read tHashinput and delet the records from Table A.
is this your issue resloved?
please accept solution and provide kudos.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Find out how to migrate from one database to another using the Dynamic schema
Learn how to make your data more available, reduce costs and cut your build time
Read about OTTO's experiences with Big Data and Personalized Experiences