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
How to do the error handling of if ur source is flatfiles?
Explain the scenario which compels informatica server to reject files?
How can informatica be used for an organization?
tell me 5 session failure in real time how can you solve that in your project?
What is a filter transformation?
What do think which one is the better joiner or look up?
How do you load first and last records into target table?
Mention some types of transformation?
Explain the different lookup methods used in informatica?
Briefly describe lookup transformation?
What are the differences between a connected lookup and unconnected lookup?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What is the benefit of partitioning a session?
Define filter transformation?
How to join three sources using joiner? Explain though mapping flow.