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
Generation Of Surrogate Keys
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
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.
Generation Of Surrogate Keys in Parallel Jobs
Ray
Thanks for your suggestions
Nivas
Thanks for your suggestions
Nivas
-
- Participant
- Posts: 75
- Joined: Tue May 13, 2003 4:14 am
- Location: California
- Contact: