Page 1 of 1
surrogate key
Posted: Wed Nov 11, 2009 12:17 pm
by femil
how can i create a surrogate key in data stage for a target table in which records are inserted by two passive stages
Posted: Wed Nov 11, 2009 12:19 pm
by ArndW
Use the routine "KeyMgtGetNextValueConcurrent" in both streams or use a database surrogate key (i.e. a database sequence).
Generating Sequence value
Posted: Wed Nov 11, 2009 10:56 pm
by ramu1
Hi Friends,
We can use Keymgmtgetnextval also to create sequence values.
What is the difference between Keymgmtgetnextval and KeymgmtgetnextvalConcurrent?
Thanks&Regards
Ramu
Posted: Wed Nov 11, 2009 11:08 pm
by ray.wurlod
The difference is in persistence of the lock on the sequence. Review the source code of each routine to ascertain the difference.
Posted: Thu Nov 12, 2009 6:19 am
by chulett
Right, the 'Concurrent' part is a big clue and the long descriptions of each explain the difference between the two.