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.