Hi All,
Without using Sequence Generator Transmation, How to create a sequence number in target table?
Prakash:)
Printable View
Hi All,
Without using Sequence Generator Transmation, How to create a sequence number in target table?
Prakash:)
take lookup on tgt which is unconnected, call it in Exp Trans using variable ports, u need two variable ports to achive this
Hi Mark,
I think lookup is a costly transformation, using expression itself we can achieve this task.
SEQ_NO - Variable Port
IIF(ISNULL(SEQ_NO),1,SEQ_NO+1)
Please get back to us in case of queries.
Thx
Prakash:)
hi Prakash,
that works for single load, reload, or to generate numbers to a non unique or non primary key column.
Do you have logic to generate numbers to a warehouse key? which requires to find the max key value then start giving max+1 . In this case lookup is needed to find the max key value
please let me know if you have any questions