Search Results: snowflake

• 
  Normalization vs. Dimensional Modeling

  This article is a basic overview and comparison between normalization and dimensional modeling.

  Author:  ShawnHarrison     Date: 1/11/2010     Section: Article

  tags : dimensional, fact, snowflake, star, normalization
• 
  To Flatten or Not to flatten?

  I've gotten some data that my users would like to see collected periodically(prolly quarterly) and I'd like to take all of my newfound knowledge and put it to the test. Problem is, I'm nervous about designing it wrong ;) Any suggestions would be most welc

  Author:  SQLKohai     Date: 7/1/2011     Section: Blog
• 
  Modelling cube with fact tables at different grains

  Hi All, Please help! I have 2 table in my relational database - DailyData and CampaignFlight . I need to create a star (or snowflakes) schema so I can build an SSAS cube off it. I'm having problem modelling this because of the granularity of the fact tabl

  Author:  Jaysen     Date: 4/13/2011     Section: Forum
• 
  DW design question

  You can do it either way. Personally I would put them all in one dimension. Using one dimension will create the more classic STAR rather than a SNOWFLAKE dimensional model.

  Author:  Daniel     Date: 8/2/2011     Section: Forum