Duplicate Surrogate Key - Generating min numbers

[mohan]

Hi All,

we have a job which was running fine from past 1 year, suddenly we are seeing that while inserting new records it is getting very small number from surrogate key file stage. Now the number for new records are like 38,39,50 etc...

The job design is as follow :


Target lookup
to find insert/update

src oracle stage - > surrogate stage---> dataset -> target table


We have reset the surrogate file to max value, however for few records everyday, it is generation a min value.

The following are the properties for surrogate key stage:

Generate key from last highest value : yes
user-specified block size = 1
partitioning type = round robin


we have 6 job using the same surrogate key file and all the jobs has similar design( only source extract criteria is different). the only difference I could find out is that 3 jobs has user-specifed block size =1 and for remaining 3 there is not block size defined.

appriciate your help.

Thanks and Regards,
Mohan

[ArndW]

I am a bit unclear as to what the problem is, apart from you getting different values from expected. Is the key value being reset to 38 on each run, or is it counting up appropriately but is now a low value?

If you manually check your key file from a UNIX shell, what is the value there? How did you reset it to high value (and what do you consider "high value" to be)?

[Sainath.Srinivasan]

Are you sure that those records are not from update stream for existing records ?