DSXchange

Hi,

I have a requirement where i need to write the dulicate records occuring in the source file on the basis of some key to the target file.

How can handle this in datastage?
Can i have some counter (constriant )

Thanks,

Yes and yes.

Can u tell me how to define stage variable in this case

Refer this link:
http://dsxchange.com/viewtopic.php?t=10 ... 648414b7a7

Run the data through a Sort stage, and get the Sort stage to create a key change column. In a downstream Transformer stage, the key change column will identify the beginning of each group - that is, of each set of duplicates. Constrain on the key change column - where it is reset (0) you have a duplicate.