1.

What Can We Do To Improve The Performance Of Informatica Aggregator Transformation?

Answer»

Aggregator PERFORMANCE improves dramatically if records are sorted before passing to the aggregator and "sorted input" option under aggregator properties is checked. The record set should be sorted on those columns that are used in Group By OPERATION.

It is often a good idea to sort the record set in database level e.g. INSIDE a source qualifier TRANSFORMATION, unless there is a chance that ALREADY sorted records from source qualifier can again become unsorted before reaching aggregator.

Aggregator performance improves dramatically if records are sorted before passing to the aggregator and "sorted input" option under aggregator properties is checked. The record set should be sorted on those columns that are used in Group By operation.

It is often a good idea to sort the record set in database level e.g. inside a source qualifier transformation, unless there is a chance that already sorted records from source qualifier can again become unsorted before reaching aggregator.


Discussion

No Comment Found

Related InterviewSolutions