Answer Detail: RE: what is the difference between E-R modelling and D...

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?

February 02, 2007 21:41:31	#2
noverino	Member Since: December 2006 Total Comments: 6
RE: what is the difference between E-R modelling and D...
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