Sequence Number

[cme_prak]

Hi All,

Without using Sequence Generator Transmation, How to create a sequence number in target table?

Prakash

[markdanny]

take lookup on tgt which is unconnected, call it in Exp Trans using variable ports, u need two variable ports to achive this

[cme_prak]

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

[markdanny]

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