Page 1 of 1
To generate sequence number to the ouput rows
Posted: Mon Feb 14, 2011 4:20 am
by ksv2584
Please let me know the best way to generate the sequence number(1,2,3, ...9999) to the output rows
Re: To generate sequence number to the ouput rows
Posted: Mon Feb 14, 2011 4:51 am
by boppanakrishna
You can use transformer stage to genetate the sequence.
Posted: Mon Feb 14, 2011 7:13 am
by jwiles
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,
Posted: Mon Feb 14, 2011 3:33 pm
by ray.wurlod
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.