Hi,
Thanks for the input. I am trying the other method too.
I am using version 8.1. Is there any routine available here?
Regards,
Deepa
Search found 93 matches
- Mon Sep 28, 2009 11:38 pm
- Forum: General
- Topic: Surrogate Key Generation using DS routine
- Replies: 13
- Views: 3343
- Mon Sep 28, 2009 9:33 am
- Forum: General
- Topic: Surrogate Key Generation using DS routine
- Replies: 13
- Views: 3343
Thanks guys!! I realised its possible only in Server Jobs and not in Parallel Jobs. Is there any simple efficient method to generate Surrogate Keys in sequence, in a parallel job, without using Database Sequence?? I tried using the Flat File option but it generates surrogate keys like 1,1001,2001,20...
- Fri Sep 25, 2009 1:13 am
- Forum: General
- Topic: Surrogate Key Generation using DS routine
- Replies: 13
- Views: 3343
Surrogate Key Generation using DS routine
Hi All, I am completely new to DataStage and I am yet to learn the basics. I would like to know how to generate surrogate keys in a sequential order using DS Routine. Do we use KeyMgtGetNextValue()? If yes, how exactly do we go about using it in the Transformer stage? I used a Stage Variable, but am...