Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / rameshbabu.katikireddy
In literature on data warehousing are created in Oracle using a schema object called a materialized view. Materialized views can be used to perform a number of roles, such as improving query performance or providing replicated data, as described below.
In data warehouses, materialized views can be used to recompute and store aggregated data such as sum of sales. Materialized views in these environments are typically referred to as summaries since they store summarized data. They can also be used to recompute joins with or without aggregations. So a materialized view is used to eliminate overhead associated with expensive joins or aggregations for a large or important class of queries.
Posted by
Rameshbabu.katikireddy
Time:jan.11.2012,6:20pm
Contact09767696346
Karimnagar
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What are aggregate transformation?
What are situations where snow flake schema is better than star schema to use and when the opposite is true?
What is incremintal loading?
What are data modeling and data mining? Where it will be used?
What are the steps involved in creating dimensional modeling process?
What is the difference between snowflake and star schema?
Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?
What is the differences between star and snowflake schemas?
What are components of report studio?
Explain what are the various methods of getting incremental records or delta records from the source systems?
What is loop in data warehousing?
What is analytical or analytic mean?
What are the different types of join operations?
Explain clearly how to explain any (sales) project in interview. Actually feom where report developer work starts?pls reply as soon as possible?
What is a real-time data warehouse? How is it different from near to real-time data warehouse?
