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

Facebook Login
Site Registration
Print Preview

How can we improve performance of aggregator transformation?

+2 votes
112 views
posted Jul 4, 2013 by anonymous

Share this question
Facebook Share Button Twitter Share Button Google+ Share Button LinkedIn Share Button Multiple Social Share Button

1 Answer

+1 vote
  1. Sort the data before passing into aggregator. The integration service uses memory to process the aggregator transformation and it does not use cache memory.
  2. Filter the unwanted data before aggregating.
  3. Limit the number of input/output or output ports to reduce the amount of data the aggregator transformation stores in the data cache.
  4. When data is sorted in that case data will read and aggregate for that group no staging will happen. Here parallel operation happen while in not sorted data sequential operation will happen.
answer Jul 17, 2013 by Shatark Bajpai

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