Rules for data warehouse design and implementation

Here are some rules I follow when designing data warehouse.

  1. Fact attributes, which will be joined to dimensions can not be null. Instead add some predefined constant.