Basic help
Moderators: chulett, rschirm, roy
Basic help
give me the logic to generating sequence number without using surrogate key generator.
reddy
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:
Note that this will start at 1 each run.
Code: Select all
((@INROWNUM-1)*@NUMPARTITIONS)+(@PARTITIONNUM+1)
generating sequence number
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.
Sequence Number can be generated in form of row number in Sequential file Stage as well.
sequential file stage--->output--->properties-->options-->RowNumberColumn.