Join 2 table and delete

Six Stars

Join 2 table and delete

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


Accepted Solutions
Thirteen Stars

Re: Join 2 table and delete

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

Manohar B

All Replies
Employee

Re: Join 2 table and delete

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.

Thirteen Stars

Re: Join 2 table and delete

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.

Manohar B
Six Stars

Re: Join 2 table and delete

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.

Six Stars

Re: Join 2 table and delete

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

Thirteen Stars

Re: Join 2 table and delete

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

Manohar B
Thirteen Stars

Re: Join 2 table and delete

is this your issue resloved?

Manohar B
Six Stars

Re: Join 2 table and delete

I'm sorry to late reply.

I resolve with your suggest

Thnx at all

best regards

Thirteen Stars

Re: Join 2 table and delete

please accept solution and provide kudos.

Manohar B