surrogate key generator stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
sk39758
Participant
Posts: 17
Joined: Mon Mar 02, 2009 10:22 pm

surrogate key generator stage

Post 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.
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:

Post 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.
Post Reply