Data Integration Solution Architect / Data Architect

Looking for challenges. Contact me on Linkedin.

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.