Selecting the Third Normal Form or a Dimensional model
Using the Third Normal Form or a Dimensional model to support your data warehouse solution is an important and highly debated decision within the industry. Primary reasons for choosing one over the other include:
Skills and capabilities within the organizations
Preferences
The approach to building your warehouse solution
Getting ready
Understand the differences and limitations of a Third Normal Form and or a Dimensional-modeling approach to building your warehouse. Research the technology you plan to implement, to understand which model it works more optimally with.
How to do it...
Third Normal Form modeling is normally used within Online Transaction Processing Applications (OLTP). Dimensional modeling has been refined over the years and is generally accepted for data warehouses:
1. Determine the modeling approach for the initial stage area, which houses a copy of the source. Typically, here you will mirror the source system. Note, you will...
