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 is difference between query studio and report studio?
Explain is fact table?
Which component has onread method and what it is used for?
Explain what is a cube in data warehousing concept?
Explain some of modeling tools available in the market?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.
Explain normalization?
Explain what are the methodologies of data warehousing?
What is normalization, first normal form, second normal form, third normal form?
Explain why fact table is in normal form?
what are the major three types of modeling used?
Explain the versions of reportnet?
What are the steps of implementing data warehousing?
Explain difference between view and materialized view?
What is Active Datawarehousing?
