Dimensional Modeling for Data Warehouse
Many surveys indicate that a significant percentage of DWs fail to meet business objectives or are outright failures. In this paper, the authors are describing about multidimensional data model for the DWs, which will help in surround facts with as much relevant context dimensions. Multidimensionality is just a design technique that separates the information into facts and dimensions. It gives rise to schema with star shape, Consists of a fact table with a single table for each dimension. Snowflake Schema is a variation of star schema, in which the dimensional tables from a star schema are organized into a hierarchy by normalizing them.