Using Surrogate Key stage
Posted: Wed Apr 15, 2009 3:54 pm
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.
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.