top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration
Print Preview

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

+1 vote
402 views
posted Aug 11, 2013 by Abhay Kulkarni

Share this question
Facebook Share Button Twitter Share Button Google+ Share Button LinkedIn Share Button Multiple Social 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

Useful Links with Similar Problem
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#470/147, 3rd Floor, 5th Main,
HSR Layout Sector 7,
Bangalore - 560102,
Karnataka INDIA.
QUERY HOME
...