Answer Posted / 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 is is a star schema?

1083

---

What is a real-time data warehouse?

956

---

Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?

2066

---

What is execution plan?

1165

---

what are the other factors of the database on which the loading performance depend?

1861

---

Explain what are slowly changing dimensions?

975

---

Compare and contrast aggregates & indexes

3723

---

What is data cleaning? How can we do that?

991

---

What is vdl (view definition language) explain?

994

---

Explain the definition of normalized and denormalized view?

845

---

Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?

1169

---

How to reduce warnings?

906

---

How to design file watch jobs?

930

---

how can one transfer LOB and user defined data from oracle to warehouse using ETL informaticabecause

2093

---

Explain datawarehousing?

1005

---