surrogate key
Moderators: chulett, rschirm, roy
surrogate key
how can i create a surrogate key in data stage for a target table in which records are inserted by two passive stages
Use the routine "KeyMgtGetNextValueConcurrent" in both streams or use a database surrogate key (i.e. a database sequence).
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Generating Sequence value
Hi Friends,
We can use Keymgmtgetnextval also to create sequence values.
What is the difference between Keymgmtgetnextval and KeymgmtgetnextvalConcurrent?
Thanks&Regards
Ramu
We can use Keymgmtgetnextval also to create sequence values.
What is the difference between Keymgmtgetnextval and KeymgmtgetnextvalConcurrent?
Thanks&Regards
Ramu
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: