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
Mention few advantages of router transformation over filter transformation.
What is different between the data warehouse and data mart?
Informatica settings are available in which file?
What does cheating measurement mean?
What is a shortcut and copy in Informatica and how two are different with each other?
What is informatica etl tool?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
What the difference is between a database, a data warehouse and a data mart?
Define filter transformation?
Explain lookup transformation is active in informatica
What are the settings that you use to configure the joiner transformation?
How do you load alternate records into different tables through mapping flow?
Define mapping and session?
Describe an informatica powercenter?
What is the different lookup cache(s)?