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
- 8424 Views
- IBM, I also Faced
- E-Mail Answers
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 to load data in informatica ?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What is confirmed fact in dataware housing?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What is complex mapping?
4 yrs etl devloper roles and responsibilities?any body give solutions
What is the way to execute pl/sql script using informatica mapping?
Explain the shared cache and re-cache?
What is the commit type if you have a transaction control transformation in the mapping?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
what is the difference between informatica6.1 and infomatica7.1
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What do you understand by term role-playing dimension?
In warehouses how many schemas are there?
