Table of Contents

  1. Dimensional and Fact Modelling

  2. Dimensions

  3. Facts

  4. Referential Integrity – Buckets and Dummies

  5. Type 2 Dimensions

  6. Types of Hash Keys

  7. What If ?

  8. Potential Issues

  9. Advantages

  10. Practical Implementation

  11. Enhanced Strategy - Improvements over basic strategy

  12. Enhanced Strategy - Speed Objects

  13. Enhanced Strategy - Dummy Instances

  14. Quantifying Viability and Evaluation