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
Surrogate Key
Moderators: chulett, rschirm, roy
Surrogate Key
EssEss
Re: Surrogate Key
Not true. Read the documentation a little more carefully.EssEss05 wrote:I have tried with surrogate key generator stage but its not possible to specify the highest value of last run.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
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
EssEss
Check this ...http://dsxchange.com/viewtopic.php?p=21 ... ca8#214862