Rules for data warehouse design and implementation Here are some rules I follow when designing data warehouse. Fact attributes, which will be joined to dimensions can not be null. Instead add some predefined constant. Tweet