Interested to Buy Any Domain ? << Click Here >> for more details...
How Materialized Views are linked with Oracle DataWare
house?
- 1 Answers
- 6553 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 |
Explain in simple terms, the concept of Data Mining.
Explain what is partitioning? What are the types of partitioning?
How to reduce warnings?
Explain why are oltp database designs not generally a good idea for a data warehouse?
What do you mean by static and local variable?
What is the use of dimensional modeling in data warehousing?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meet the condition 333 after we create a scd table, can we use that particular dimension as a dimension table for star schema?
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
What is pre-emptive and non-pre-emptive?
In a star schema, are foreign key constraints between facts and dimensions neccessary?
Explain what are the methodologies of data warehousing?
What are the other names given to data warehousing?
Teradata 
