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?
You can use tMap with Inner Join
main flow from Table A
lookup flow from table B
both output flow inside tMap from Table A
1 matched, 1 rejected
from each output tFlowToIterate and tRunJob