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
COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Performance tuning in UNIX for informatica mappings?
Explain the tuning lookup transformation - informatica
Explain load alternative records / rows into multiple targets - informatica
Write the unconnected lookup syntax and how to return more than one column.
What is a repository manager?
Where are the source flat files kept before running the session?
How to create the source and target database connections in server manager?
hi real timers . iam waiting for ur reply regarding ETL TESTING
What do you mean by enterprise data warehousing?
Differentiate between sessions and batches?
How can we delete duplicate rows from flat files?
Explain the code page compatibility?
What are ETL Tools?