Four Stars

Diff from DB Tables

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?


  • Data Integration
Nine Stars

Re: Diff from DB Tables

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