When working on a multidimensional design, every fact table within scope should be handled with care. In an ideal world, each low-level fact table represents the metrics related to a business event.

Referential integrity (RI)is a method for ensuring the “correctness” of data within a DBMS. People tend to oversimplify RI, stating that it is merely the identification of relationships between ...