Data Warehouse Developer Question:
Download Job Interview Questions and Answers PDF
Explain me what is the difference between view and materialized view?
Answer:
View:
☛ 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.
☛ 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.
Download Data Warehouse Developer Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Tell us what does subject-oriented data warehouse signify? | Do you know what does Metadata Respiratory contain? |