top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

How can we improve performance of aggregator transformation?

+2 votes
388 views
How can we improve performance of aggregator transformation?
posted Jul 4, 2013 by anonymous

Share this question
Facebook Share Button Twitter Share Button LinkedIn 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
...