Interested to Buy Any Domain ? << Click Here >> for more details...
How can Oracle Materialized Views be used to speed up data
warehouse queries?
- 3 Answers
- 13402 Views
- I also Faced
- E-Mail Answers
Answer Posted / svs rajesh
In oracle materialized view carry the carry with them so it
is easy 7 faster to retrieve the data for reporting instead
of goin to the actual database these provide the faster
retrieval of data.
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?
What is is the guidelines to build universe with better performance? R performance tuning issues of universes?
Explain can report net connect multiple datasource at a time in report creation time?
What is an error log table in informatica occurs and how to maintain it in mapping?
Can you state some of the innovations throughout history?
Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?
What is the difference between power center and power mart?
What is meant by metadata in context of a data warehouse?
Explain multivalued dependency?
What is the difference between filter and lookup transformation?
What are Non-additive facts?
Explain what is the advantages data mining over traditional approaches?
How to generate iqd file from framework manager?
What is load manager?
