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.?
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
Explain direct and indirect flat file loading (source file type) - informatica
What are the types of schemas we have in data warehouse and what are the difference between them?
What is mapplet in informatica?
What are batches?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is the benefit of session partitioning?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
What is the sequence generator transformation in informatica?
How are indexes created after completing the load process?
What are the issues you have faced in your project? How did you overcome those issues?
What is the function of look up transformation?
How to go to the older version for a mapping?
What is the use of source qualifier?
What is sequence generator transformation in informatica?
what is the size of your data warehousing?