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
Can you explain how sorter increases performance of aggregator?
ReplyDelete