| |
GeekInterview.com > Interview Questions > Data Warehousing > DataStage
| Print | |
Question: Dimensional modelling is again sub divided into 2 types.
Answer:
a)Star Schema - Simple & Much Faster. Denormalized form.
b)Snowflake Schema - Complex with more Granularity. More normalized form.
|
| May 05, 2008 12:37:54 |
#3 |
| reddy074 |
Member Since: April 2008 Total Comments: 1 |
RE: Dimensional modelling is again sub divided into 2 types.
|
A Dimmensional modelling consists of 3 phases
a. Conceptual Modelling
b. Logical Modelling
c. Physical Modelling |
| |
Back To Question | |
