Aggregator stage internal processing

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
sendmkpk
Premium Member
Premium Member
Posts: 97
Joined: Mon Apr 02, 2007 2:47 am

Aggregator stage internal processing

Post by sendmkpk »

Hi,

I want to know, how internally Aggregator stage does count opertaion?

does it do the count on each partition and sum it out to the output?

or does it do it in a sequential mode?
Praveen
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Neither. It does a count on each node. End of story.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
sendmkpk
Premium Member
Premium Member
Posts: 97
Joined: Mon Apr 02, 2007 2:47 am

Post by sendmkpk »

Thx again for reply, its so simple for you ray, its confusing For me

So that means it counts at each node and sum it up at the end to give one value, yes?
Praveen
jwiles
Premium Member
Premium Member
Posts: 1274
Joined: Sun Nov 14, 2004 8:50 pm
Contact:

Post by jwiles »

No, it means just as Ray indicated: It does a count on each node that Agreggator is executing on.

If you need a single count across all nodes, you must run an Aggregator (or other stage) in a single node (i.e. sequential) in order to combine the counts. Aggregator is no different from other parallel stages in this regard.

Regards,
- james wiles


All generalizations are false, including this one - Mark Twain.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

While the job is running in parallel (let's assume on four nodes) you will have four counts. Nothing will sum those together unless you create more stages to do so, or unless you run your Aggregator on a single node (that is, in Sequential mode).
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