Q1. List out all the differences between the operational data and Decision support system data?
Q2. What do you mean by data granularity? Describe with illustration.
Q3. Describe the merits of star schema.
Q4. Describe the event-snapshot interaction which causes the data warehouse to become populated with the data.
Q5. Describe how proper partitioning can advantage the data warehouse.
Q6. List what type of functionality is needed as data passes from the operational, legacy environment to the data warehouse atmosphere.
Q7. Describe the four levels of data in the architectural atmosphere.