Genarating a sequence number

balu124 · Post by **balu124** » Tue Oct 30, 2007 6:09 am

Hi ,

We need to genatrate a sequence number ,for that we used the sourogate key genarator. it works fine for initial load .

My requirement is the sequence number has to be continue (starting from higiest value+1 ) in the next runs.

for the I wish to take a lookup of target table on which the data is loading

My question is what is the lookup condition that I have to mention and how to get the maximum value of that perticular key in the previous run
can any one give some idea on this?

Maveric · Post by **Maveric** » Tue Oct 30, 2007 6:23 am

Do a search on "Sequence number". See if those posts help.