How can yoU improve session performance in aggregator
transformation?

Answer Posted / haritha

use sorted input option to decrease the use of aggregator
cache.

use filter transformation before aggregator transformation
to to rduce unnecessary aggregation.

Limit the number of connected input/output or output ports
to reduce the amount of data the Aggregator transformation
stores in the data cache.

Is This Answer Correct ?    39 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you remove duplicate records in informatica? And how many ways are there to do it?

719


To import the flat file definition into the designer where should the flat file be placed?

681


What is a snowflake schema?

573


How to do unit testing in informatica?

729


1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

1693






Is stop and abort are same in informatica?

574


Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?

611


what is mean by complex business rule ?

1723


How to configure mapping in informatica?

682


what is degenerated dimension?

3160


How can you define user defied event?

626


What are the different transaction levels available in transaction control transformation?

681


What is the Rank index port in Rank transformation?

672


What are the various types of transformation?

646


can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4318