Answer Detail: RE: What is Difference between E-R Modeling and Diment...

GeekInterview.com > Interview Questions > Data Warehousing > Basics

Print |

Question: What is Difference between E-R Modeling and Dimentional Modeling.

March 03, 2006 18:41:43	#1
Uma	Member Since: Visitor Total Comments: N/A
RE: What is Difference between E-R Modeling and Diment...
Basic diff is E-R modeling will have logical and physical model. Dimensional model will have only physical model. E-R modeling is used for normalizing the OLTP database design. Dimensional modeling is used for de-normalizing the ROLAP/MOLAP design.