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 / koti
To do aggr. caliculations function it needs some time.. we
can reduce that time by providing sorted I/P. The time is
less which can takes to forward the rows from sorter to
aggregator rather than the time to do aggr. calculations
without sorted data.....
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
How to call shell scripts from informatica?
What is data transformation manager process?
Clarify the aggregator change?
What is an expression transformation in informatica?
Enlist some properties of sessions.
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
server hot-ws270 is connect to Repository B. What does it mean?
What is the meaning of up gradation of repository?
What is the scenario which compels informatica server to reject files?
What is deployment group?
What are the designer tools for creating transformations?
What is the use of code page?
Implementation methodology