| |
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 06:35:52 |
#2 |
| madhava1238 |
Member Since: May 2008 Total Comments: 7 |
RE: Dimensional modelling is again sub divided into 2 types.
|
1. star schema 2.snow-flake schema
star schema ia denormalisation process
snow flake schema is a normalisation process.
performance wise snow flake schema is better |
| |
Back To Question | |
