topic Re: Diff from DB Tables in Talend Studio

Diff from DB Tables

Anonymous — Fri, 11 Aug 2017 17:30:43 GMT

Hello everybody,

i have this problem.

I have two tables A,B.

Foreach record stored in A i need to check if it is already stored on table B. if it's true, I run a Job X otherwise I run a Job Y.

How can i do that?

Thanks.

vapukov — Sat, 12 Aug 2017 03:04:42 GMT

You can use tMap with Inner Join

main flow from Table A

lookup flow from table B

Inner JOIN

both output flow inside tMap from Table A

1 matched, 1 rejected

from each output tFlowToIterate and tRunJob

Anonymous — Tue, 22 Aug 2017 13:56:44 GMT

Forgive me, but I'm not so practical about Talend.

I have done the inner join but now I don't Know I can iterate each result and so go on with tRunJob.

As you can see from the image below, I don't know how to handle the tmap and TFlowToIterate.

How can I do what you have said?

Thanks

vapukov — Wed, 23 Aug 2017 02:07:39 GMT

t not possible to answer full - because I can not see, what are You doing in tMap, why it marked as error (red !)

but answer for Your original question:

Foreach record stored in A i need to check if it is already stored on table B. if it's true, I run a Job X otherwise I run a Job Y.

You must have 2 output from tMap
- matched

- rejected

each of components must be connected to tFlowToIterate and each of them to tRunJob

attache - samples, how tMap INNER JOIN work

as I understand Your picture, in Your case both connections inside tMap must be from Lar