Q1. Describe at least four advantages of granularity of data in the warehouse design.
Q2. Distinguish between the OLTP systems and Decision Support systems.
Q3. Describe the various ways in which the technology can support efficient index access?
Q4. Write down an algorithmic path to compute the row or space occupied through a data warehouse.
Q5. Explain how is the dimensional modeling tool better suitable for a data warehousing as compared to the semantic data model similar to ER model?
Q6. Illustrate one merit and one demerit of multiple platforms in management of common detail in Distributed Data warehouse.
Q7. Describe the merits of a star schema.