| |
GeekInterview.com > Interview Questions > Data Warehousing > DataStage
| Print | |
| Question: Dimension Modelling types along with their significance
Answer:
Data Modelling is Broadly classified into 2 types.
a) E-R Diagrams (Entity - Relatioships).
b) Dimensional Modelling.
|
| May 05, 2008 06:54:39 |
#2 |
| madhava1238 |
Member Since: May 2008 Total Comments: 7 |
RE: Dimension Modelling types along with their significance
|
Dimension modelling means to define a datawarehouse architecture using any one of the availabale schema
dimensionl modelling are 3 types 1. conceptual model 2. logical model
3.physical model
conceptual model: gathering of all the requirements
logical modelling:define facts and dimension
physical mosel:physically moving data to datawarehouse
datawarehouse graph: gathering all requirement--->define facts and dimension--->load data(datawarehouse)--->generate reports--->analysis--->decision
Thanks & Regards,
Madhava
+91-9962016141 |
| |
Back To Question | |
