Page 1 of 1

surrogate key generator stage

Posted: Tue Oct 05, 2010 12:25 am
by sk39758
hi there,
just wanna know answer to below questions....
1.Can surrogate key generate stage handle concurrency like KeyMgtGetNextValueConcurrent() in server?
2. how do we make sure that generated keys are continuous..means there should not be gaps in generated key using surrogate key generated stage.

Posted: Tue Oct 05, 2010 2:07 am
by ArndW
1. Yes
2. Unless you choose a block size of 1 and also commit your output every records, you cannot guarantee that there won't be an gaps. Neither of these two options is generally acceptable in production for performance reasons.