how do we generate surroget keys

[bunny]

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 .

[rgandra]

hi

You can use the routines like gennextkey to generate surrogate keys.

-sandeep

[ray.wurlod]

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.

[Luk]

you can use GetNextKeyValue routine in transformer stage to generate integer number sequence wchich you can link with old keys and use it as surrogate keys