Interested to Buy Any Domain ? << Click Here >> for more details...
How can yoU improve session performance in aggregator
transformation?
- 8 Answers
- 27667 Views
- TCS, I also Faced
- E-Mail Answers
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
Explain where to store informatica rejected data? How to extract the informatica rejected data?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are the features of complex mapping?
how to load rows into fact table in data warehouse
What is sq transformation?
Explain pushdown optimization $pushdownconfig parameter - informatica
Can you use flat files in Mapplets.
Is there any target staging area in informatica not staging area
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What is a mapplet/worklet in informatica?
What is an Integration service in Informatica?
Define mapplet?
Can we change Dynamic to Static or Persistent cache? If so what happens?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
How an expression transformation differs from aggregator transformation?
