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 a relationship?
Can you pass sql queries in filter transformation?
In my report contain product name, amount, country, sales person I want to create one prompt: sales territory.( Ex: asia, us, uk, aus), but territory column is not there in my model and source if u select the asia in prompt page-ll asian country results I want in report page I discussed with my friends and colleague, they told use the static choice function still I face this problem. If u know please tell me?
Who needs data warehousing?
Store (and count) non-fact records?
Why should we use data ware housing and how can you extract data for analysis with example?
What is difference macros and prompts?
What is the main difference between inmon and kimball philosophies of data warehousing?
Explain why fact table is in normal form?
What is meant by metadata in context of a data warehouse?
How do we design a universe?
Explain difference between view and materialized view?
Which component has onread method and what it is used for?
Explain hybrid slowly changing dimension?
can anybody mail me the FAQS for hyperion essbase amd planning