Tuesday, October 19, 2010

Kimball: The 10 Essential Rules of Dimensional Modeling

Rule #1: Load detailed atomic data into dimensional structures.
Rule #2: Structure dimensional models around business processes.
Rule #3: Ensure that every fact table has an associated date dimension table.
Rule #4: Ensure that all facts in a single fact table are at the same grain or level of detail.
Rule #5: Resove many-to-many relationships in fact tables.
Rule #6: Resolve many-to-one relationships in dimension tables.
Rule #7: Store report labels and filter domain values in dimension tables.
Rule #8: Make certain that dimension tables use a surrogate key.
Rule #9: Create conformed dimensions to integrate data across the enterprise.
Rule #10: Continuously balance requirements and realities to deliver a DW/BI solution that's accepted by business users and that supports their decision-making.