Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8332 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / bhupal
if u wont use the sorted input the aggregator transformation will reads the records and keep until all the calculations are done.
if we provided the sorted input it reads the records and release the records reaching next first record of new group.
the integration service will creates the cache for only the sorter keys and only one cache in sorter t/r. so by providing the sorted input we get the performance advantage.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
scenario where i can use only concurrent execution of workflow.
What differs when we choose the sorted input for aggregator transformation?
Have you worked with/created Parameter file
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are the modules in Power Center
What is the reusable transformation?
Design time, run time. If you don't create parameter what will happen
How to use procedural logic inside infromatica?
what are 3 tech challenges/ common issues you face?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What is aggregate cache in aggregator transformation?
How do you set a varible in incremental aggregation
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
Is it possible to revert a global repository to local one and why?
What are the tuning techniques you applied during your last project
