Page 1 of 1
Basic help
Posted: Sat Jul 21, 2012 12:54 am
by sachin518
give me the logic to generating sequence number without using surrogate key generator.
Posted: Sat Jul 21, 2012 4:22 am
by ArndW
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.
generating sequence number
Posted: Sat Jul 21, 2012 1:41 pm
by bhasds
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.