Link to home
Avatar of RamzyNEbeid
RamzyNEbeidFlag for Egypt

asked on

new Data warehouse for Retail Sales and snowflakes design

Dear all
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.

thanks,
ASKER CERTIFIED SOLUTION
Avatar of Ryan McCauley
Ryan McCauley
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial