Performance of Aggregator

[dsuser08]

Hi

I have to achieve below result :

Select empid,sum(sal)+100 from X
group by empid

Please let me know if its better ( with respect to performance) to use Aggregator and transformer to achieve above result or Database component with SQL query and a transformer


Thanks

[niharranjan]

i think using aggregator

[ray.wurlod]

It depends (as always). If the grouping columns are supported by indexes, then it may well be faster to do it in the database. If you have sorted data, then it may be faster to use an Aggregator stage. Is the database local or remote? If remote, it may be better to aggregate in the database, because you would send fewer rows across the network. And so on. It depends.