-
Contributing Member
Sequence Number
Hi All,
Without using Sequence Generator Transmation, How to create a sequence number in target table?
Prakash
-
Junior Member
Re: Sequence Number
take lookup on tgt which is unconnected, call it in Exp Trans using variable ports, u need two variable ports to achive this
Last edited by markdanny; 01-15-2008 at 07:35 AM.
-
Contributing Member
Re: Sequence Number
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
-
Junior Member
Re: Sequence Number
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules