in Big Data | Hadoop by (2.6k points)

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

1 Answer

0 votes
by (2.6k points)

Aggregator performance improves dramatically if records are sorted before passing to the aggregator and if the ‘sorted input’ option under Aggregator Properties is checked. The record set should be sorted on those columns that are used in the Group By operation. It is often a good idea to sort the record set in the database level, e.g., inside a source qualifier transformation, unless there is a chance that the already sorted records from the source qualifier can again become unsorted before reaching the aggregator.

Related questions

+1 vote
asked Mar 10, 2020 in Big Data | Hadoop by Hodge (2.6k points)
0 votes
asked Apr 6, 2020 in Big Data | Hadoop by GeorgeBell (5.2k points)
0 votes
asked Jan 12, 2020 in Big Data | Hadoop by sharadyadav1986 (31.7k points)