surrogate key stage's start value

[djoni]

do the keys generated start at the start value at every run of the job that uses the surrogate key stage?
or the next value after the last run's highest value?

djoni

[kumar_s]

Hi djoni,
Yes it will restart.
If you need the key to continue from the previou run, you need to fram the logic of the surrogate key by yourself may be in transformer.

-Kumar

[vmcburney]

You can set the surrogate key start value to a job parameter and pass in the start value every time you run the job. The max value can be retrieved by the Sequence job by a shell execute script that runs SQL or isql or db2 commands.