want to pass unique and dup record seperately

deesh · Post by **deesh** » Tue Jun 14, 2011 7:05 am

Hi,

Any one can suggest me
how to pass single input file unique and duplicate records seperately in different outputs without usage of transformer stage.

DSguru2B · Post by **DSguru2B** » Tue Jun 14, 2011 7:45 am

Look into sort stage and filter stage.

ray.wurlod · Post by **ray.wurlod** » Tue Jun 14, 2011 3:00 pm

Use a fork join design and a downstream filter on the count. The solution has been posted previously on DSXchange.

deesh · Post by **deesh** » Tue Jun 14, 2011 11:23 pm

Hi All,
Problem was solved. see the below process.

source file---> select option in Sort stage (Create Key change column (True)), it produce unique records in "1", dup records in "0",----> Filter stage take two output links one for dup, second for unique records filter based on create key column basis.

If any one not understand, let reply to me i will give more informaion.

want to pass unique and dup record seperately

want to pass unique and dup record seperately

Re: want to pass unique and dup record seperately