In the job , we are using one column with data type as 16-bit integer(SMALLINT) and the data range has exceeded in this month when we started from 31161 + 3883 and job has created same key for multiple records instead of failing and its ran successful . Its may be tool issue. Raised the case#TS003863112.
|Who would benefit from this IDEA?||As a customer this will benefit the people using the Surrogate Key limit reached|
How should it work?
The job should fail when the limit is reached.
|Priority Justification||The job is running sucessfully on the PROD which should not be the case as the incorrect data is getting loaded.|