to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?
- 3 Answers
- 7880 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / james
Sorted input in an aggregator transformation does not use
cache instead it uses the memory. Reading from memory is
faster than reading from cache.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is the meaning of up gradation of repository?
What is rank transformation?
What is meant by lookup transformation? Explain the types of lookup transformation?
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Design a mapping to load the cumulative sum of salaries of employees into target table?
Informatica settings are available in which file?
In informatics server which files are created during the session rums?
What are the designer tools for creating transformations?
What are the advantages of using informatica as an etl tool over teradata?
What is an active transformation?
Is it possible to create multiple domains on a single Informatica server?
What is blocking transformation?
What are session parameters ? How do you set them?
What can we do to improve the performance of informatica aggregator transformation?
