Aggregator
|
Sorter
|
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
|
A blog where you can explore everything about Datawarehouse, OBIEE, Informatica, Power BI, QlikView, Hadoop, Oracle SQL-PLSQL, Cognos and much more....
Thursday 13 September 2012
Difference between Sorter and Aggregator in Informatica
Subscribe to:
Post Comments (Atom)
Amazing observations! Informatica community would have been incomplete without you. Hats off to you buddy!
ReplyDelete