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
can anyone explain me about retail domain project in informatica?
Define filter transformation?
Is there any target staging area in informatica not staging area
Which version configuration tool used in ur project?
What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?
Slowly changing dimensions, types and where will you use them
Define Pmrep command?
Is it possible to define a single node as a Gateway node as well as worker node?
what are the deliverables?in your project?
what is index?how it can work in informatica
Differentiate between source qualifier and filter transformation?
What is a joiner transformation and why it is an active one?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What are the different components of powercenter?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar