Using Surrogate Key stage

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
mydsworld
Participant
Posts: 321
Joined: Thu Sep 07, 2006 3:55 am

Using Surrogate Key stage

Post by mydsworld »

My requirement is to create huge No. of Surrogate keys with stat file.

Please let me know the job design. Shd it be something like :

1. Surrogate key stage only - create a stat file

2. <Input stage> -> SKG stage -> <Output stage>

what will be the option like generate from last SK value.

what is the best practise followed.

Thanks.
Post Reply