Q1. Distinguish between the operational data and Decision Support System data.
Q2. Describe how the system development life cycle for the data warehouse is just opposite to the classical SDLC.
Q3. Describe the four levels of data in the architectural environment.
Q4. Is data in the data warehouse homogenous or heterogeneous? Describe with an illustration.
Q5. What do you mean by granularity? Explain why it is significant in data warehouse?
Q6. Describe ‘Normalization’ in the data warehouse. List all its benefits.
Q7. List all the changes to be made in the corporate data model when it is to be applied to the data warehouse.