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.
surrogate key generator stage
Moderators: chulett, rschirm, roy
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.
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>