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
How can we delete duplicate rows from flat files?
server hot-ws270 is connect to Repository B. What does it mean?
Reusable transformation and shortcut differences
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What are the advantages of informatica?
Explain informatica architecture - version 8 / 9
What is the commit type if you have a transaction control transformation in the mapping?
What is a joiner transformation?
What happens when a session fails and you click on recover?
how to load rows into fact table in data warehouse
What is meant by lookup transformation? Explain the types of lookup transformation?
What you know about transaction control transformation?
what are 3 tech challenges/ common issues you face?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
How can we use batches?