Join 2 table and delete

Highlighted
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
Forteen 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
Don't forget to give kudos/accept the solution when a replay is helpful.

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.

Forteen 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
Don't forget to give kudos/accept the solution when a replay is helpful.
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

Forteen 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
Don't forget to give kudos/accept the solution when a replay is helpful.
Forteen Stars

Re: Join 2 table and delete

is this your issue resloved?

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Six Stars

Re: Join 2 table and delete

I'm sorry to late reply.

I resolve with your suggest

Thnx at all

best regards

Forteen Stars

Re: Join 2 table and delete

please accept solution and provide kudos.

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now