Need to Create Surrogate Key at Script Level

praburaj · Post by **praburaj** » Thu Feb 05, 2009 11:20 pm

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

ray.wurlod · Post by **ray.wurlod** » Fri Feb 06, 2009 12:15 am

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!!!