Surrogate Key Generator

[Coles]

Hi All,

I am using surrogate key Generator in Transformer defined in a test file..

Can someone let me know if there is an option to set the max value..

Once the max value is reached I need to reset the file.

I don't see an option to pre-set the max value in properties tab of Surrogate key in Transformer stage.

Regards
Coles

[ray.wurlod]

There isn't directly, as that would be anathema to the concept of "surrogate key".

You could do it, but not within the context of a single job.