Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have developed a job thats supposed to track changes by comparing two sources and create an output insert. My tMap has a variable expression defined as below. My records are in millions of rows and performance it not very good. Any ideas please. - thank you in advance.
source1.customerid.equals(source2.customerid) && source1.hashing.equals(source2.hashing)? "no change":"changed"
Can you share the tMap?
What kind of join do you have between the main and the lookup row?