Dimensional Modeling design
3 posters
Page 1 of 1
Dimensional Modeling design
I am very new to Dimensional Modeling.
IS there any rule that i need to follow while designing my model.
Which data to move into Facts and Dimensions?
There are lot of topics covered in internet on the same.
But wanted to know a rule or something that i need to follow while analzying data.
I am a newbie sorry if this question is really basic to answer.Apologies again,
IS there any rule that i need to follow while designing my model.
Which data to move into Facts and Dimensions?
There are lot of topics covered in internet on the same.
But wanted to know a rule or something that i need to follow while analzying data.
I am a newbie sorry if this question is really basic to answer.Apologies again,
SathyJaanu- Posts : 20
Join date : 2015-10-07
Re: Dimensional Modeling design
Here are the basics:
#1. Forget most of what you learned about entity relationship modeling. Dimensional modeling is a different methodology.
#2. Facts represent business events or states. They contain dimension foreign keys, degenerate dimension values and measures.
#3. Dimensions provide context to facts. They contain attributes of the entity the dimension represents.
#1. Forget most of what you learned about entity relationship modeling. Dimensional modeling is a different methodology.
#2. Facts represent business events or states. They contain dimension foreign keys, degenerate dimension values and measures.
#3. Dimensions provide context to facts. They contain attributes of the entity the dimension represents.
Re: Dimensional Modeling design
..and read Ralph's book on Dimensional Modelling: http://www.amazon.com/gp/product/1118530802?keywords=ralph%20kimball&qid=1444391632&ref_=sr_1_1&s=books&sr=1-1
nick_white- Posts : 364
Join date : 2014-01-06
Location : London
Similar topics
» Design Fact Table in Dimensional Modeling with Multiple Grain
» Dimensional data modeling CASE tool and DW design practice
» Reasons to use a 3NF design over a Dimensional Model design for an EDW - Discussion
» Dimensional Modeling-Checklist
» Advantages of Dimensional Modeling
» Dimensional data modeling CASE tool and DW design practice
» Reasons to use a 3NF design over a Dimensional Model design for an EDW - Discussion
» Dimensional Modeling-Checklist
» Advantages of Dimensional Modeling
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum