Thursday, 13 September 2012

Difference between Sorter and Aggregator in Informatica

Aggregator transformation performs aggregate calculations, such as averages and sums.
Sorter Transformation is used to sort the data
Aggregator uses aggregate cache  to perform aggregate calculations
Sorter uses Sorter cache to perform the sort operation
Aggregation done by  using aggregate expression with conditional clauses,
Sorting is done based on the sort key and the order of sort key
Aggregator uses Incremental aggregation to perform aggregation calculations incrementally.
There is nothing called incremental aggregation in sorter

1 comment:

  1. Amazing observations! Informatica community would have been incomplete without you. Hats off to you buddy!


Related Posts Plugin for WordPress, Blogger...