How Materialized Views are linked with Oracle DataWare
house?



How Materialized Views are linked with Oracle DataWare house?..

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

Post New Answer

More Data Warehouse General Interview Questions

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

0 Answers   L&T,


What is "method/1"?

0 Answers  


Is union transormation is active transformation?

0 Answers  


After the generation of a report to whom we have to deploy or what we do after the completion of a report?

0 Answers  


Briefly state different between data ware house & data mart?

0 Answers  






Explain what is cost benefit analysis (cba)?

0 Answers  


What is difference between a connected look up and unconnected look up?

1 Answers  


Explain what are the various reporting tools in the market?

0 Answers  


What is the difference between olap and datawarehosue?

0 Answers  


Explain what is full load & incremental or refresh load?

0 Answers  


What is core dimension?

0 Answers  


Explain what are components of reportnet?

0 Answers  


Categories