Page 1 of 1

Need to Create Surrogate Key at Script Level

Posted: Thu Feb 05, 2009 11:20 pm
by praburaj
Hi All

I want to create surrogate key based on my natural key for my job at UNIX script level.I don't know how to create at script level.plz help me to resolve this issue.
EX:

Code S.key
000T01 1
000T02 2
000T03 3
000T04 4

Posted: Fri Feb 06, 2009 12:15 am
by ray.wurlod
Why "at script level"? If that's mandatory why did you waste your money buying DataStage? And how do you propose to handle uniqueness across parallel processing nodes?

Resist stupid requirements!!!