Alternative way to generate surrogate keys

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
akshu.agni
Participant
Posts: 17
Joined: Tue Jan 25, 2011 5:24 am
Location: Bangalore

Alternative way to generate surrogate keys

Post by akshu.agni »

Hi,

How can i generate surrogate keys without using surrogate key generator stage in datastage??

Regards
Aks
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Lots of ways.

How many have you thought of?

When's the interview?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
developeretl
Participant
Posts: 89
Joined: Sat Jul 24, 2010 11:33 pm

Re: Alternative way to generate surrogate keys

Post by developeretl »

akshu.agni wrote:Hi,

How can i generate surrogate keys without using surrogate key generator stage in datastage??

Regards
You can do it through Transformer Stage. Go to transformer stage properties there you can see the surrogate key tab.
Post Reply