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
- 13235 Views
- I also Faced
- E-Mail Answers
Answer Posted / sabeena
A materialized view is a database object that contains the
results of a query. They are local copies of data located
remotely, or are used to create summary tables based on
aggregations of a table's data. Materialized views, which
store data based on remote tables are also, know as
snapshots.
A materialized view can query tables, views, and other
materialized views. Collectively these are called master
tables (a replication term) or detail tables (a data
warehouse term).
For data warehousing purposes, the materialized views
commonly created are aggregate views, single-table
aggregate views, and join views.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What are the different types of fact tables used in data warehousing?
hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit
Tell me what is full load & incremental or refresh load?
How would you write a left join statement to return a result set of movie.title�s and director.name�s?
what is an use case?
How to pivot row data using informatica?
What is called data cleaning?
What is the difference between mapping parameter & mapping variable in data warehousing?
How can you communicate with web server (apache or iis) from coldfusion?
What is an error log table in informatica occurs and how to maintain it in mapping?
Explain what is a cube in data warehousing concept?
Explain what are the steps to build the data warehouse?
Explain what is partitioning? What are the types of partitioning?
Code the tables statement for a single-level (most common) frequency?
What is data cleaning? How can we do that?
