DSXchange

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 .

hi

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

-sandeep

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.

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