top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

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

+1 vote
946 views
What can we do to improve the performance of Informatica Aggregator Transformation?
posted Aug 11, 2013 by Abhay Kulkarni

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

2 Answers

+1 vote
 
Best answer

Use Sorter Transformation to pass the sorted data into Aggregator Transformation.

answer Aug 14, 2013 by Shatark Bajpai
0 votes

Source: http://www.dwbiconcepts.com/etl/14-etl-informatica/47-tuning-informatica-aggregator.html

If you have to do the aggregation using Informatica aggregator, then ensure that all the columns used in the group by are sorted in the same order of group by and “Sorted Input” option is checked in the aggregator properties. Ensuring the input data is sorted is absolutely must in order to achieve better performance and we will soon know why.

Other things that need to be checked to increase aggregator performance are –

  1. Check if “Case-Sensitive String Comparison” option is really required. Keeping this option checked (default) slows down the aggregator performance
  2. Enough memory (RAM) is available to do the in memory aggregation.
  3. Aggregator cache is partitioned
answer Aug 14, 2013 by Salil Agrawal
...