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?
Genarating a sequence number
Moderators: chulett, rschirm, roy