new Data warehouse for Retail Sales and snowflakes design
Posted on 2011-09-06
I will start to create my first data warehouse.
All my work will be with SQL Server 2008 R2, SSIS, SSAS, SSRS
I will start by Retail Sales, I did read the part of retail sales from “The Data Warehouse
Toolkit Second Edition the Complete Guide to Dimensional Modeling” for Ralph Kimball
So far the data warehouse structure is clear for me but there are some points I want to clarify.
What is the advantage and disadvantage of the snowflakes? (Example Product and Sub category and the Category) if I didn’t use the snowflake how will I show this data later in the cube.