DSXchange

Once a surrogate key is generated on an out row for a column, is this keeps on increasing even if we delete all data and reload.

Is there any way if we can generate from starting number after deleting all data from target table?

thanks,
tom

You can always reset the value of your key. So you can set any value you want, you can go back to one as well.

Simplest thing to do, is to have a process, which will find out the Max value of ID column. This value then in turn can be used to reset the SK.

IHTH.

How, exactly, are you generating the value? The mechanism for resetting the sequence will differ depending on your answer.

Of course, if it's a surrogate key the actual value is irrelevant; all a surrogate key provides is uniqueness.

How to reset SK value?

thanks,
Tom

As noted, depends on how it is being generated.

I am generating using KeyMgtGetNextValue(%Sequence Name%).
So if I delete all rows in target table, and run with source data. How to reset SK ID to start from id=1.

thanks,
Tom

Search is your friend! I got 13 hits when searching for all words and 'reset KeyMgtGetNextValue'. Many of them have the actual reset syntax in them.

You can use the UPDATE SDKSequences directly in the Administrator command, or get its content via a hashed file with 2 columns (SequenceName as key and NextValue). Then perform the update in Transformer against the Sequence Name.

gateleys