Page 1 of 1
how can i generate a sequence number in parallel jobs
Posted: Mon Mar 22, 2010 1:12 am
by nandela.sudheer
how can i generate a sequence number in parallel jobs
Re: how can i generate a sequence number in parallel jobs
Posted: Mon Mar 22, 2010 1:36 am
by rameshv
[quote="nandela.sudheer"]how can i generate a sequence number in parallel jobs[/quote]
Using surrogate generaator stage
Re: how can i generate a sequence number in parallel jobs
Posted: Mon Mar 22, 2010 2:48 am
by nandela.sudheer
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
Posted: Mon Mar 22, 2010 3:16 am
by rohithmuthyala
Make the execution mode in transformer as Sequential in stage properties.....keep a counter which adds one for every record..!!
Posted: Mon Mar 22, 2010 3:29 am
by ray.wurlod
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