| |
GeekInterview.com > Interview Questions > Concepts > Data Modeling
| Print | |
Question: In which normal form is the dimension table and fact table in the schema?
|
| March 03, 2008 21:56:31 |
#2 |
| SashaFroyland |
Member Since: March 2008 Total Comments: 6 |
RE: In which normal form is the dimension table and fact table in the schema?
|
Unlike OLTP, the goal of dimensional and fact modeling is not to achieve the highest Normal Form but rather to make key performance indicators (often sought after measures) readily accessible to ad-doc query.
That being said, Dimensions can strive to be in Boyce-Codd 3rd normal form, while fact tables may be in 1st normal form - having only a primary key being unique.
De-normalized dimensional tables may be in only 1st normal form but have the advantage of low storage space, while de-normalized 1st normal form dimensional table take more space but perform faster.
In my opinion, this kind of interview question has no single correct answer. It's a question to get the interviewee to demonstrate their knowledge of normalization and dimensional modeling and the pros and cons of normalization and de-normalization with respect to query speed vs. physical storage. |
| |
Back To Question | |
