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
How do you remove duplicate records in informatica? And how many ways are there to do it?
To import the flat file definition into the designer where should the flat file be placed?
What is a snowflake schema?
How to do unit testing in informatica?
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?
Is stop and abort are same in informatica?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
what is mean by complex business rule ?
How to configure mapping in informatica?
what is degenerated dimension?
How can you define user defied event?
What are the different transaction levels available in transaction control transformation?
What is the Rank index port in Rank transformation?
What are the various types of transformation?
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