Page 1 of 1

Function to check duplicate values in record

Posted: Wed Jun 02, 2010 10:00 am
by rameshkm
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.

Posted: Wed Jun 02, 2010 10:23 am
by anbu
Use Create Key Change column option in Sort to find duplicates

Posted: Wed Jun 02, 2010 10:47 am
by ETLJOB
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 :idea: