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.

What are data modeling and data mining? Where it will be used?

0 Answers  

---

how to calculate sum(sal) with out using aggregator satge

3 Answers   HSBC,

---

How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?

0 Answers  

---

How Materialized Views are linked with Oracle DataWare house?

1 Answers   Kirloskar,

---

What are the types of partitioning?

0 Answers  

---

Compare and contrast aggregates & indexes

0 Answers   IBM, TCS,

---

What is difference macros and prompts?

0 Answers  

---

Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?

0 Answers  

---

How to create diff. Types of templates?

0 Answers  

---

How do we design a universe?

0 Answers  

---

What is confirmed dimension?

7 Answers   JPMorgan Chase,

---

How to drill through from a powerplay cube to reportnet?

0 Answers  

---