Dimensional Modeling design

View previous topic View next topic Go down

Dimensional Modeling design

Post  SathyJaanu on Wed Oct 07, 2015 9:43 am

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,

SathyJaanu

Posts : 20
Join date : 2015-10-07

View user profile

Back to top Go down

Re: Dimensional Modeling design

Post  ngalemmo on Wed Oct 07, 2015 11:42 am

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.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Dimensional Modeling design

Post  nick_white on Fri Oct 09, 2015 6:54 am


nick_white

Posts : 366
Join date : 2014-01-06
Location : London

View user profile

Back to top Go down

Re: Dimensional Modeling design

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum