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

Cloud Free Trial

Try Talend Cloud free for 30 days.

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.