Home > Software > Data-Warehouse > Informatica
Interview Questions   Tutorials   Discussions   Programs   

Informatica - What can we do to improve the performance of Informatica Aggregator Transformation?




569
views
asked SRVMTrainings December 18, 2011 06:13 AM  

What can we do to improve the performance of Informatica Aggregator Transformation?


           

1 Answers



 
answered By SRVMTrainings   0  
Aggregator performance improves dramatically if records are sorted before passing to the aggregator and \"sorted input\" option under aggregator properties is checked. The record set should be sorted on those columns that are used in Group By operation. It is often a good idea to sort the record set in database level (why?) e.g. inside a source qualifier transformation, unless there is a chance that already sorted records from source qualifier can again become unsorted before reaching aggregator
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert