Kind of wonder if you had experienced the similar issue - Surrogate Key Generator produced sequence number with a gap.
Backgrouund info:
===========
(1) the state file is deleted and created every time before the job is run
(2) expect the Surrogate key number start from 1 and increment by 1
(3) Job ran with 2 node configuration
Result:
====
(1) input = 503598 rows of data processed through
(2) the highest value of Surrogate key generated = 503799
(3) from debug, found one gap = 201 in between the sequence number as below
Gen# Gap Partition#
------ ---- ------------
"498798","1","0"
"498799","1","0"
"499001","202","1"
"499002","1","1"
"499003","1","1"
The sequence number is growing okay from 1 upto 498799 between partition 0 and partition 1. Then found this one unexpected gap. After this gap, the sequence number beyond this point continued growing normally between partition 0 and partition 1 with no issue.
Any insight or advice ?
C.
Surrogate Key Generator - produced sequence num with a gap
Moderators: chulett, rschirm, roy