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
What is the meaning of up gradation of repository?
Tell me about MD5 functions in informatica
What is sq transformation?
During the running session, output files are created by informatica server. Enlist few of them.
What is a surrogate key?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What is a grid in Informatica?
What is the difference between source qualifier transformations source filter to filter transformation?
What are the components of workflow manager?
Can informatica load heterogeneous targets from heterogeneous sources?
What is a pre-defined event and user-defined event?
What is a rank transform?
Why is sorter an active transformation?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What is InformaticaPowerCenter?