Hi,
This is very basic question. I know, this must have been discussed already. I tried searching the forum, but couldnt find the right link.
I need to generate Surrogate key using Surrogate key Gen stage.
This is what I did.
I created a job with a Row Gen and Surroage Key stage and created a Surrogate key file.
Used the same file path in the actual job where the value has to be used in Transformer. Used the NextSurrogateKey() to increment the value.
Its working so far. But Iam not sure, what to pass the Initial Value as. So for every run, the jobs starts the value from '1' which I had given. I need to make it increment from the last value of the previous run. May I now the right option on what do I pass the first time and what do I pass each time?
Thanks.
Surrogate Key Generation
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There are three job designs using the SKG stage.
A job with no input or output link will create the state file.
A job with an input link only can be used to initialize the state file.
A job with an output link only can be used to deliver surrogate key values.
A job with no input or output link will create the state file.
A job with an input link only can be used to initialize the state file.
A job with an output link only can be used to deliver surrogate key values.
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.
For example: Generating surrogate keys.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers