vvk.kotamraju

 Profile Answers by vvk.kotamraju Questions by vvk.kotamraju

• Nov 17th, 2006

 

E-R modeling is the relation between entities in the form of normalization.

Dimensional modeling is the relation between dimensions in the form of de normalization.

noverino

 Profile Answers by noverino Questions by noverino

• Feb 22nd, 2007

 

ER modeling:
  - focused how data will be efficient for processing (insert, update, delete)
  - Minimalize (limit to zero) data redundancies

Dimensional:
  - focused how data will be efficient for retrieving
    (example, by report and analysis tools).
  - many data redundancies
  - Consist of Fact and Dimension table

jgd.ramesh

• Aug 15th, 2007

 

E-R modelling is entity relation between two table.
Dimension modelling is contain three table Aggregate, Fact table, Dimension table

njvijay

 Profile Answers by njvijay 

• May 12th, 2008

 

//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.