DSXchange

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.

Hi,
Using the group by clause, will make your job look simple and easy to debug.
If the data volume is large, Aggregator might give be better option.

Ketfos