Explain me what is the difference between view and materialized view?
Submitted by: MuhammadView:
☛ Tail raid data representation is provided by a view to access data from its table.
☛ It has logical structure that does not occupy space.
☛ Changes get affected in corresponding tables.
Materialized view:
☛ Pre-calculated data persists in materialized view.
☛ It has physical data space occupation.
☛ Changes will not get affected in corresponding tables.
Submitted by: Muhammad
☛ Tail raid data representation is provided by a view to access data from its table.
☛ It has logical structure that does not occupy space.
☛ Changes get affected in corresponding tables.
Materialized view:
☛ Pre-calculated data persists in materialized view.
☛ It has physical data space occupation.
☛ Changes will not get affected in corresponding tables.
Submitted by: Muhammad
Read Online Data Warehouse Developer Job Interview Questions And Answers
Top Data Warehouse Developer Questions
| ☺ | Explain me why is chameleon method used in data warehousing? |
| ☺ | Tell us what is Hybrid SCD? |
| ☺ | Tell us what is the main difference between Inmon and Kimball philosophies of data warehousing? |
| ☺ | Can you list the Schema that a data warehouse system can implements? |
| ☺ | Tell us what is Virtual Warehouse? |
Top Data Warehouse Job Categories
| ☺ | Warehouse Assistant Interview Questions. |
| ☺ | Ab Initio Interview Questions. |
| ☺ | Data Stage Interview Questions. |
| ☺ | ColdFusion Interview Questions. |
| ☺ | Data Warehouse Supervisor Interview Questions. |
