To generate sequence number to the ouput rows

ksv2584 · Post by **ksv2584** » Mon Feb 14, 2011 4:20 am

Please let me know the best way to generate the sequence number(1,2,3, ...9999) to the output rows

boppanakrishna · Post by **boppanakrishna** » Mon Feb 14, 2011 4:51 am

You can use transformer stage to genetate the sequence.

jwiles · Post by **jwiles** » Mon Feb 14, 2011 7:13 am

The Surrogate Key Generator and Transformer stages are both capable of being used to general sequence numbers. How to use them to do so has been covered many times in this forum so a quick search should point you towards many examples.

Regards,

ray.wurlod · Post by **ray.wurlod** » Mon Feb 14, 2011 3:33 pm

Depends what the producer stage for the output rows is. If it's a Transformer, use that. Otherwise use a Column Generator or Surrogate Key Generator stage.

DSXchange

To generate sequence number to the ouput rows

To generate sequence number to the ouput rows

Re: To generate sequence number to the ouput rows