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.
Try Talend Cloud free for 30 days.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.