surrogate key generating off numbers
Posted: Fri Jun 26, 2015 9:40 am
I am developing a new job to an existing target table. I decided to initialize the seq with max+1 value to skey file and do an update/insert into the table, so created job to load the data to the target table, whenver there is no lookup found i generate the SKey from the utility, data is generated correctly. but i see the Skey generation is generating numbers which are less than the max
+1 value which i set in intialization stage. please advice the workaround.
+1 value which i set in intialization stage. please advice the workaround.