Join 2 table and delete

[chichibio]

Hi guys,

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

from tableA.

It's possible? How I can do it? 

thnx at all

[Anonymous]

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.

[manodwhb]

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.

[chichibio]

thanx at all

I think will try the manodwhp solutions..

However I have 2 different db: mysql and oracle. But I think is not a problem.

[chichibio]

I can't use buffer because usually I have million of record... so the job it's stopped cause out of memory

[manodwhb · Accepted solution]

Instead of writing to memory,write to textfile and read the same file and try to delete from Table A

[manodwhb]

is this your issue resloved?

[chichibio]

I'm sorry to late reply.

I resolve with your suggest

Thnx at all

best regards

[manodwhb]

please accept solution and provide kudos.