Hi
I am loading data to 19 tables parallel .I want to generate Unique Surrogate key .If i use surrogate key stage in the shared container
will it works ? can it assign unique key in all the tables...
thks
surrogate key
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The Surrogate Key Generator stage can not do anything except generate unique keys (provided you use the same source consistently) unless you re-initialize it. It doesn't matter what these keys are used for.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Re: surrogate key
I tested the same some time back and it worked for me. As Ray said, you need to provide the same file and path to all the jobs.
DS User
DS User