Interested to Buy Any Domain ? << Click Here >> for more details...
How Materialized Views are linked with Oracle DataWare
house?
- 1 Answers
- 6656 Views
- Kirloskar, I also Faced
- E-Mail Answers
Answer / satya
Materialized views are schema objects that can be used to
summarize, precompute, replicate, and distribute data. E.g.
to construct a data warehouse.
A materialized view provides indirect access to table data
by storing the results of a query in a separate schema
object. Unlike an ordinary view, which does not take up any
storage space or contain any data.
The existence of a materialized view is transparent to SQL,
but when used for query rewrites will improve the
performance of SQL execution. An updatable materialized view
lets you insert, update, and delete.
You can define a materialized view on a base table,
partitioned table or view and you can define indexes on a
materialized view.
A materialized view can be stored in the same database as
its base table(s) or in a different database.
Materialized views stored in the same database as their base
tables can improve query performance through query rewrites.
Query rewrites are particularly useful in a data warehouse
environment.
| Is This Answer Correct ? | 9 Yes | 0 No |
What is meant by metadata in context of a data warehouse and how it is important?
Explain what is a cube in data warehousing concept?
What is ETL process in Data warehousing?
What are the different types of schemas used in data warehousing?
Are facts same as metrics and dimensions same as measures? If not , please tell the difference?
How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?
Can any one explain about core dimension, balanced dimension, and dirty dimension?
What is a hash cluster?
What is the difference between narmal load and bulk load?
Is there any rownum object from which we can do this?
What is fact less fact table? Where you have used it in your project?
What is is the guidelines to build universe with better performance? R performance tuning issues of universes?
Teradata 
