generate surrogate key in transformer

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
arnie_nits
Participant
Posts: 101
Joined: Mon Aug 13, 2007 2:32 am

generate surrogate key in transformer

Post by arnie_nits »

Hi
I am new to Data stage.

I want to generate surrogate key in the transformer .I have done it by putting a column gen. before the tarnsfrmer. But I want it done using only a transformer.

Regards
Arnie
Top
ravibabu
Participant
Posts: 39
Joined: Tue Feb 13, 2007 12:18 am
Location: vijayawada

Post by ravibabu »

Hi ,


Use the below logic .


@PARTITIONNUM + (@NUMPARTITIONS * (@INROWNUM - 1)) + 1
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”