How Part and Part count working in row generator

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Dozzy
Participant
Posts: 1
Joined: Fri Nov 23, 2007 3:55 am

How Part and Part count working in row generator

Post by Dozzy »

Hi,
I need to generate sequence id using the row generator by using part and part count.

The sequence id is generating correctly but i need to know how it is generating for th 4 node partition. can any one please explain me this with an example.
Thanks & Regards,
Dozzy
ray.wurlod
Participant
Posts: 54595
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Welcome aboard.
Partition numbers for four nodes are 0, 1, 2 and 3. Partition count is 4.
Plug these into a generator using partnum for initial value and partcount for increment; on the fourth node (node #3) the values will be 3, 7, 11, 15 and so on.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply