data warehouse design and how to make relation between specific tables
Posted on 2011-09-15
I am working on my data warehouse with start schema structure it is retial sales
I have my Fact table is “Fact Sales”
I have a target Header and Target details in my OLTP database.
I want to add the targets tables to my warehouse database
So my idea of thinking is the following:
• I will create a new table “Dim Targets” and I will relate this table to “Fact Sales”
• I will create a new table “DimTargetDetails” and I will relate this table to “Dim Targets”
As far as my understanding that this structure is called snowflake design?
Is there any other way that I can avoid the snowflake design?
Is this a good design or bad one?