hi to all,
i am new to datatstage, i am working on datastage enterprise edition. input data contains fundname as one of the filed, in output i have to generate system generated identifier for based on fund name. how it is possible . i know that we have to generate surrogate key for each fundname, but i don't know how to generate surrogate keys.
in parallel jobs we have to use surrogate key generator, how do we generate in server jobs?
thanks .
how do we generate surroget keys
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Depending on your data base you may also be able to use a sequence or a SERIAL data type or a GUID. All a surrogate key has to be is unique, but you must have some mechanism for returning it to DataStage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.