Function to check duplicate values in record

rameshkm · Post by **rameshkm** » Wed Jun 02, 2010 10:00 am

Hi,
I am in need a function to check duplicate values on record in transformer, is there any function available in parallel. please help in thism thanks in advance.

anbu · Post by **anbu** » Wed Jun 02, 2010 10:23 am

Use Create Key Change column option in Sort to find duplicates

ETLJOB · Post by **ETLJOB** » Wed Jun 02, 2010 10:47 am

You may have to define few stage variables and compare previous record value with the current record value based on your key columns. You can have an additional flag variable to mark the duplicate records. Just an idea