DSXchange

Reading about it in the Parallel Job Developers Guide may be faster then asking about it on this forum.

The stage generates sequentially incrementing unique integers from a given starting point. The existing columns of the data set are passed straight through the stage.

If the stage is operating in parallel each instance will increment by the number of partitions to ensure the numbering is unique. You can duplicate this functionality in a transformer by creating a counter set to @partitionnum - @numpartitions and incrementing it by @numpartitions. I would go for the specialist key generator stage unless you already have a transformer in your job.

Searching the forum will yield faster results on different methodologies used for generating sakeys.

We use the column generator, the transformer and the DB stage to generate surrogate keys. Pls search the forum.

HTH
Rich