how can i generate a sequence number in parallel jobs

nandela.sudheer · Post by **nandela.sudheer** » Mon Mar 22, 2010 1:12 am

rameshv · Post by **rameshv** » Mon Mar 22, 2010 1:36 am

[quote="nandela.sudheer"]how can i generate a sequence number in parallel jobs[/quote]

Using surrogate generaator stage

nandela.sudheer · Post by **nandela.sudheer** » Mon Mar 22, 2010 2:48 am

by using Transformer Stage how can i generate the Sequence Number.

rameshv wrote:
nandela.sudheer wrote:how can i generate a sequence number in parallel jobs

Using surrogate generaator stage

rohithmuthyala · Post by **rohithmuthyala** » Mon Mar 22, 2010 3:16 am

Make the execution mode in transformer as Sequential in stage properties.....keep a counter which adds one for every record..!!

ray.wurlod · Post by **ray.wurlod** » Mon Mar 22, 2010 3:29 am

Initialize a stage variable - let's call it svSeqNo - to the partition number (system variable @PARTITIONNUM). Derive it with an expression that increments it by the number of partitions (system variable @NUMPARTITIONS), for example

Code: Select all

svSeqNo + @NUMPARTITIONS

DSXchange

how can i generate a sequence number in parallel jobs

how can i generate a sequence number in parallel jobs

Re: how can i generate a sequence number in parallel jobs

Re: how can i generate a sequence number in parallel jobs