Basic help

sachin518 · Post by **sachin518** » Sat Jul 21, 2012 12:54 am

give me the logic to generating sequence number without using surrogate key generator.

ArndW · Post by **ArndW** » Sat Jul 21, 2012 4:22 am

I'm not sure exactly what you want, but in a transform stage if you want to generate a unique number regardless of how many partitions you have the formula is:

Code: Select all

((@INROWNUM-1)*@NUMPARTITIONS)+(@PARTITIONNUM+1)

Note that this will start at 1 each run.

bhasds · Post by **bhasds** » Sat Jul 21, 2012 1:41 pm

Hi Sachin518,

Sequence Number can be generated in form of row number in Sequential file Stage as well.

sequential file stage--->output--->properties-->options-->RowNumberColumn.