topic Re: Join 2 table and delete in Talend Studio

Join 2 table and delete

chichibio — Sat, 16 Nov 2024 08:47:38 GMT

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

Re: Join 2 table and delete

Anonymous — Mon, 29 Jan 2018 18:06:09 GMT

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.

Re: Join 2 table and delete

manodwhb — Tue, 30 Jan 2018 07:08:49 GMT

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.

Re: Join 2 table and delete

chichibio — Tue, 30 Jan 2018 11:32:41 GMT

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.

Re: Join 2 table and delete

chichibio — Tue, 30 Jan 2018 11:34:15 GMT

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

Re: Join 2 table and delete

manodwhb — Wed, 31 Jan 2018 06:18:09 GMT

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

Re: Join 2 table and delete

manodwhb — Thu, 01 Feb 2018 11:21:38 GMT

is this your issue resloved?

Re: Join 2 table and delete

chichibio — Tue, 13 Feb 2018 10:36:52 GMT

I'm sorry to late reply.

I resolve with your suggest

Thnx at all

best regards

Re: Join 2 table and delete

manodwhb — Tue, 13 Feb 2018 11:37:27 GMT

please accept solution and provide kudos.