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 comment:

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

    ReplyDelete

Related Posts Plugin for WordPress, Blogger...

ShareThis