GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Tech FAQs  >  Informatica

 Print  |  
Question:  Dimensional modelling vs Data modelling vs ER modelling

Answer: What is Dimensional modelling ? What is the difference between Data modelling and Dimensional modelling and Erwin modelling.


February 02, 2008 04:51:02 #1
 pal.amol   Member Since: February 2008    Total Comments: 8 

RE: Dimensional modelling vs Data modelling vs ER modelling
 
Dimensional modelling sometimes mistaken as the ER modelling but no it is wrong, DM is just modelling which is more flexible for the user perspective.
In ER it is not mapped unlike DM for creating schemas and  moreover it does not also act to convert normalize data in to denormalize form.

Basicalling aim of modelling data is for retrieving the data fast when user will be querying  , so it happens in DM like star schema.
     

 

Back To Question