What are the challenges of Dataware housing in the future?
Answer Posted / krishnakanth.ch
I think as we move into the future, the historical data
size increases which impacts the performace for complex
calculations or aggregations. Which also impacts at report
level to drill down.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Briefly define reusable transformation?
What is mapplet in informatica?
What is target designer and target load order?
What are junk dimensions?
What is an Integration service in Informatica?
Explain what transformation and how many are there in informatica?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Explain pushdown optimization and types in informatica
Describe an informatica powercenter?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is the use of transformation?
How does a sorter cache works?
What is rank transformation in informatica
What is complex mapping?
What are the components of the workflow manager?