Friday, 31 August 2012

How to improve the performance of an Aggregator transformation?

  • Use sorted input: Sorted input reduces the amount of data cached during the session and improves session performance. Hence use Sorter transformation and sort the data and pass to the Aggregator transformation.
  • Less number of Input\Output Ports:Use less number of connected input/output or output ports to reduce the amount of data .The Aggregator transformation stores in the data cache.
  • User Filter:In case if you are using Filter transformation use it before aggregator.This helps the Aggregator transformation to reduce unnecessary aggregation


  1. Can you explain how sorter increases performance of aggregator?

    1. This comment has been removed by the author.


Related Posts Plugin for WordPress, Blogger...