Page 1 of 1
Surrogate Key
Posted: Mon Jul 30, 2007 5:03 am
by EssEss05
Hi
I am working with Ascential datastage parallel Extender (7x), I want to know that how can we generate the surrogate key from the highest value of the last run.I have tried with surrogate key generator stage but its not possible to specify the highest value of last run.
Can I use transformer stage for the same?
Can any one help me...?
Thanks in advance
Posted: Mon Jul 30, 2007 5:18 am
by Maveric
Do an exact search on "generate surrogate key" in Parallel forum. See if one of those posts help.
Re: Surrogate Key
Posted: Mon Jul 30, 2007 7:00 am
by chulett
EssEss05 wrote:I have tried with surrogate key generator stage but its not possible to specify the highest value of last run.
Not true. Read the documentation a little more carefully.
Posted: Wed Aug 01, 2007 5:27 am
by EssEss05
Maveric wrote:Do an exact search on "generate surrogate key" in Parallel forum. See if one of those posts help.
Hi,
I can generate the surrogate key by using the transformer stage( DS Transform-----> KeyMgtGetNextVal), but that is only in the server job.
Can I do the same in the parallel transformer stage? Because in my parallel transformer stage DS Transform is not available......
Pls help me.......
Thanks & Regards
Posted: Wed Aug 01, 2007 7:03 am
by chulett
Surrogate Key stage.
Posted: Wed Aug 01, 2007 7:28 am
by balajisr
Use surrogate key stage.You can set start value as job parameter. Did you try that?
Compute your max key from the previous run and pass it as a job parameter. Set start value value to the job parameter.
Posted: Wed Aug 01, 2007 7:44 am
by swades