| |
GeekInterview.com > Interview Questions > Data Warehousing > Concepts
| Print | |
Question: what is the difference between E-R modelling and Dimendional modelling? and what are semi additive facts?
|
| May 05, 2008 02:29:39 |
#4 |
| njvijay |
Member Since: May 2007 Total Comments: 10 |
RE: what is the difference between E-R modelling and Dimendional modelling? and what are semi additive facts?
|
//Semi additive facts//
Whenever possible the facts or measure in the fact table should be chosen as perfectly additive. However some measure of intensity is not perfectly additive across all of the dimensions.
Thus some measures in the fact table is additive across atleast one dimension but not all of the dimensions so called semi additive or partially additive facts. |
| |
Back To Question | |
