DSXchange

Hi Experts,

I am generating sequence numbers by Transformer's Surrogate Key Option.Initial value is 1.

My requirement is:
Once the Surrogate key value reached to 1000,Then it has to start from Initial value.

Thanks in advance,
Phani

Mod(MySurrogateKey,1000)

Hi,
There will gap in your sequence number if input records to your transformer stage is not evenly distributed to all nodes,that you have to make sure otherwise you need to run transformer in sequential mode.

I assume RPhani is generating sequence using surrogate key (state file) but not generating numbers by formula or loop.

Use a stagevariable and map the generated value in the function as Arnd suggested:
Mod( svSurrKey,1000)

Hi,

RPhani has mentioned that he is using "Transformer's Surrogate Key" i.e. as per my understanding he want to generate sequence in Transformer stage using surrogate key feature added in version 8x.