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.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.
regarding surrogate key generator
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
Reading about it in the Parallel Job Developers Guide may be faster then asking about it on this forum.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn