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 kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
How can one identify whether mapping is correct or not without connecting session?
What are junk dimensions?
What is the use of an aggregator cache file?
What are the components of workflow manager?
Can we create multiple integration service on single repository?
What is rank transformation in informatica
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What is main use of mapplet?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
Can you generate sequence numbers without using the sequence generator transformation?
How to create Target definition for flat files?
What are the different types of olap? Give an example?
What are the tuning techniques you applied during your last project
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.