Surrogate Key

EssEss05 · Post by **EssEss05** » Mon Jul 30, 2007 5:03 am

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

Maveric · Post by **Maveric** » Mon Jul 30, 2007 5:18 am

Do an exact search on "generate surrogate key" in Parallel forum. See if one of those posts help.

chulett · Post by **chulett** » Mon Jul 30, 2007 7:00 am

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.

EssEss05 · Post by **EssEss05** » Wed Aug 01, 2007 5:27 am

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

chulett · Post by **chulett** » Wed Aug 01, 2007 7:03 am

Surrogate Key stage.

balajisr · Post by **balajisr** » Wed Aug 01, 2007 7:28 am

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.

swades · Post by **swades** » Wed Aug 01, 2007 7:44 am

Check this ...http://dsxchange.com/viewtopic.php?p=21 ... ca8#214862

DSXchange

Surrogate Key

Surrogate Key

Re: Surrogate Key