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
What is different between the data warehouse and data mart?
What do you mean by worklet?
How to go to the older version for a mapping?
Differences between connected and unconnected lookup?
What are the differences between source qualifier and joiner transformation?
explain abt ur project architecture?
What is meant by lookup transformation?
Explain the shared cache and re-cache?
What is the use of code page?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
what is degenerated dimension?
What is informatica?
Tell me about Propagate functions in informatica
What is the difference between router and filter?