Ensure conformed dimensions are created to integrate data across the enterprise.
Conformed dimensions are dimensions built with the organization perspective instead of a project prospective to support the ability to drill across and integrate data from multiple business processes. On the previous model, if Calendar is a conformed dimension, then this dimension can be used by multiple analytical applications.
Physical Data Model Adherence
All physical data models should follow the expectations in this section, plus the additional ...