How can yoU improve session performance in aggregator
transformation?
Answer Posted / swetha
Use sorted input.
The aggregator stores data in the aggregate cache until it
completes aggregate calculations. When u run a session that
uses an aggregator transformation, the informatica server
creates index and data caches in memory to process the
transformation. If the informatica server requires more
space, it stores overflow values in cache files.
Is This Answer Correct ? | 13 Yes | 5 No |
Post New Answer View All Answers
What is the difference between stop and abort in informatica
what are factless facts? And in which scenario will you use such kinds of fact tables.
can any one give some examples for pre sql and post sql(Except dropping and creating index).
How many input parameters can exist in an unconnected lookup?
How many transformations can be used in mapplets.
What is meant by lookup transformation? Explain the types of lookup transformation?
What is rank transformation?
How to Create a folder using pmrep command?
What are the modules in Power Center
How to load a Dimension ? and how to load a fact table?
How can we use mapping variables in informatica? Where do we use them?
What is a code page?
What is the sequence generator transformation in informatica?
What is incremental aggregation?
what is SDLC way of code development?