Surrogate key with cyclic option

RPhani · Post by **RPhani** » Mon Jul 22, 2013 4:59 am

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

ArndW · Post by **ArndW** » Mon Jul 22, 2013 5:37 am

Mod(MySurrogateKey,1000)

prasson_ibm · Post by **prasson_ibm** » Mon Jul 22, 2013 12:03 pm

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.

srinivas.nettalam · Post by **srinivas.nettalam** » Mon Jul 22, 2013 10:49 pm

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)

prasson_ibm · Post by **prasson_ibm** » Tue Jul 23, 2013 4:02 am

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.