Data Warehouse Manager Question:
Tell us what is the difference between View and Materialized View?
Answer:
A view is nothing but a virtual table which takes the output of the query and it can be used in place of tables.
A materialized view is nothing but an indirect access to the table data by storing the results of a query in a separate schema.
A materialized view is nothing but an indirect access to the table data by storing the results of a query in a separate schema.
| Previous Question | Next Question |
| Please explain what is Datamart? | Tell us what are the stages of Datawarehousing? |