DSXchange

Hi all,

How to generate a unique sequence number in DataStage using transformer stage?

I donot want the sequence number to be duplicated and the last record should give the count of number of records, for eg., if i pass 100 records, i should get all the values from 1 till 100 without any holes.

Thanks in advance!

Create Round Robin partition and use the logic that you are using (as specified in your other post). Again it will minimize the so called hole, but not all.
If you are more concern about sequence number, run the job in Sequential mode, atleast the Transformer and use simply @INROWNUM.

kumar_s wrote:Create Round Robin partition and use the logic that you are using (as specified in your other post). Again it will minimize the so called hole, but not all.
If you are more concern about sequence number, run the job in Sequential mode, atleast the Transformer and use simply @INROWNUM.

thanks Kumar, it worked!!!

If mark the topic, it avoids others to revisit it.

Or run the Transformer stage in Sequential execution mode.