Interested to Buy Any Domain ? << Click Here >> for more details...
How Materialized Views are linked with Oracle DataWare
house?
- 1 Answers
- 6658 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 the difference between dependent data warehouse and independent data warehouse?
What are vaious etl tools in the market?
Explain what are the various transformation available?
How to load the time dimension?
What is a look up function? What is default transformation for the look up function?
what are the different views that are considered when building an object-oriented software system?
0 Answers InfoAxon Technologies,
What is the difference between data warehouse and operational systems?
What are the different methods of loading dimension tables?
What is an OLTP (Online Transaction Processing) System?
Explain what type of indexing mechanism do we need to use for a typical datawarehouse?
Explain how to export mappings to the production environment?
Explain what are the advantages and disadvantages of reporting directly against the database?
Teradata 
