1.

How can we improve the performance of Informatica Aggregator Transformation?

Answer»

To increase the performance of Informatica Aggregator Transformation, consider the following FACTORS: 

  • Using sorted input reduces the amount of data CACHED, thus IMPROVING session performance.
  • REDUCE the amount of unnecessary aggregation by filtering the unnecessary data before it is aggregated.
  • To reduce the size of a data cache, CONNECT only the inputs/outputs needed to subsequent transformations.


Discussion

No Comment Found

Related InterviewSolutions