sort and aggregator

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
monaz
Participant
Posts: 98
Joined: Sat Aug 23, 2008 3:14 am

sort and aggregator

Post by monaz »

Hi All,

Is it a good idea to have around 3 sort stage and 3 aggregator in a single job... Is performance wise also is it good....?

In my case i have used sort and aggregator

1) for Sorting the data as per requirement

2) Sorting and doing row to column by MAX

3)Finding the number of records passed to the output file
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

As always, IT DEPENDS

Mainly on the total amount of resources the system can deliver and the total demand for those resources for all currently running applications.
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