How Can You Improve Session Performance In Aggregator Transformation?

1.	How Can You Improve Session Performance In Aggregator Transformation?
Answer» One way is supplying the SORTED input to aggregator transformation. In SITUATIONS where sorted input cannot be supplied, we need to CONFIGURE data cache and index cache at session/transformation level to allocate more space to support AGGREGATION. One way is supplying the sorted input to aggregator transformation. In situations where sorted input cannot be supplied, we need to configure data cache and index cache at session/transformation level to allocate more space to support aggregation.

Answer»

One way is supplying the SORTED input to aggregator transformation. In SITUATIONS where sorted input cannot be supplied, we need to CONFIGURE data cache and index cache at session/transformation level to allocate more space to support AGGREGATION.

One way is supplying the sorted input to aggregator transformation. In situations where sorted input cannot be supplied, we need to configure data cache and index cache at session/transformation level to allocate more space to support aggregation.

Discussion

No Comment Found

Related InterviewSolutions

When We Create A Target As Flat File And Source As Oracle. How Can I Specify First Rows As Column Names In Flat Files?
What Is Meant By Direct And Indirect Loading Options In Sessions?
What Is Difference Between Informatica 7.1 And Abinitio?
How To Join Two Tables Without Using The Joiner Transformation?
Difference Between Static And Dynamic Cache And Explain With One Example?
How The Informatica Server Sorts The String Values In Ranktransformation?
What Is Data Merging, Data Cleansing, Sampling?
What Are The Unsupported Repository Objects For A Mapplet?
Discuss Which Is Better Among Incremental Load, Normal Load And Bulk Load.
What Is Update Strategy Transformation ?