Chris Adamson’s Blog

Optional relationships are important in dimensional models. This post shows you how to support them without resorting to NULL keys in the fa...

Best practices in dimensional modeling forbid the use of NULL.  In this post, you'll learn why. In any relational database, allowing N...

People often suggest to me that a dimensional model cannot handle certain situations. These situations, the assertion holds, require falling...