DSXchange

We are about to start development in Parallel Jobs. I am putting this question in curiosity.How do we Generate Surrogate Keys in Parallel Jobs? Is there any difference from the same in Server jobs.
Any suggestions are appreciated.

thanks

Nivas

There's one very big difference from server jobs - you have parallel data streams!

Use a Column Generator stage.

1.Open properties for the Column Generator stage
2.Click on the Columns tab
3.Double-click on the positional number of the serial column you are generating.
4.Click on Generator in the Properties field.
5.Choose Type in the Available properties to add.
6.Choose Initial Value=part.
7.Choose Increment=partcount.

Or, if your target database has an auto-incrementing capability (a sequence or a serial data type), use that during the load phase.

Ray

Thanks for your suggestions

Nivas

Hi,

You can use the Surrogate Key generator stage available in version 7.0.1

Regards
Amitava