Performance of Aggregator
Posted: Tue Feb 19, 2008 12:38 am
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
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