Using many stages we can generate the sequence/increment numbers. Like Sequential file rownumber, SK, and in Transformer stage we can write user define condition like sv=1 and sv+1 based on max value. use outrownum/ partitions. or number of partitions and partition number as well.
yes we can by (flatfile,db sequence) ,go to stage properties tab,then
ReplyDeleteclik on surrogatekey tab,and fill all the require space
Using many stages we can generate the sequence/increment numbers. Like Sequential file rownumber, SK, and in Transformer stage we can write user define condition like sv=1 and sv+1 based on max value. use outrownum/ partitions. or number of partitions and partition number as well.
ReplyDelete