DSXchange

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

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.

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