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 the different types of data warehousing?
What are the differences between datamart vs. Reporting cube?
i have scheduled a report in a job in the cognos8.3 which would send the reports to the respective user ,now the repot ran and is sent to the respective user but it contains some unwanted data. So based on the senario can any one tell me that can we recall back the report ??????
Explain what is analytical or analytic mean?
Explain Association algorithm in Data mining?
Explain what is a three tier data warehouse?
What is dimension modeling?
How to limit the max no of rows retrieved in the report?
What is the main difference between inmon and kimball philosophies of data warehousing?
What are situations where snow flake schema is better than star schema to use and when the opposite is true?
explain about dirty dimension?
What are the types of partitioning?
Explain a relation schema and a relation?
How many clustered indexes can u create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
What is the difference between datawarehouse and bi?
