surrogate keys in parallel jobs

vbeeram · Post by **vbeeram** » Tue Jun 22, 2004 4:41 pm

Hi,

What is the best way to generate surrogate keys in parallel Extendeer jobs.

thanks
vbeeram

gh_amitava · Post by **gh_amitava** » Tue Jun 22, 2004 6:17 pm

Hi,

Use the Surrogate Key Generator stage available in version 7.0.1.

Regards
Amitava

richdhan · Post by **richdhan** » Tue Jun 22, 2004 11:48 pm

Hi vbeeram,

You can use the column generator stage to generate surrogate keys.
This has already been discussed before.
Pls search the datastage forum using "surrogate parallel" keywords. The results will give you an idea on what you should do.

Thanks
Rich

mandyli · Post by **mandyli** » Wed Jun 23, 2004 10:34 pm

The easy way is column generator stage only.

elavenil · Post by **elavenil** » Wed Jun 23, 2004 11:13 pm

Hi

Since we use PX 6.0, we use transformer stage to create surrogate keys. Surrogate keys are nothing but unique number. SO it can be achieved using transformer stage.

Regards
Saravanan