DSXchange

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?

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