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 meant by lookup transformation? Explain the types of lookup transformation?
What are Dimensional table?
How to call shell scripts from informatica?
How can we remove the duplicates from flat file source?
Define Pmrep command?
What is an unconnected transformation?
What can we do to improve the performance of informatica aggregator transformation?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
what is diff b/t sorter t/r and agg have the option sorter property...
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
Differentiate between source qualifier and filter transformation?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Performance tuning in UNIX for informatica mappings?
What is incremental aggregation?
What is fact table? Explain the different kinds of facts.