Regarding Aggregator
Moderators: chulett, rschirm, roy
Regarding Aggregator
Is that ok if i do the group by logic in the DRS stage itself, instead of using a Aggregator. Whether the Aggregator would, degrade the perfomance. Which is best, doing the group by caluse in the DRS stage or using a Aggregator stage.[/list]
The answer is... depends. On many things, like the setup and speed of your database and database server versus your DataStage server. Only way to really know is to do it both ways and see.
At the very least, order your output rows to support the aggregation you are doing and mark the 'Sort' columns appropriately in the stage.
At the very least, order your output rows to support the aggregation you are doing and mark the 'Sort' columns appropriately in the stage.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers