top button
Flag Notify
Site Registration

What can we do to improve the performance of Informatica Aggregator Transformation?

+1 vote
305 views

What can we do to improve the performance of Informatica Aggregator Transformation?

posted Feb 23, 2015 by Amit Sharma

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

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

answer Feb 24, 2015 by Manikandan J
...