Conformed Fact

The fact is used in more than one fact table. (Attribute)

The conformed Fact table is a fact table that can be used across multiple Data Marts.

Suppose a company has separate fact tables for Online Sales and In-store Sales. Both these fact tables might have a "Total Sales" metric.

To ensure that this metric is a conformed fact, the company would need to make sure that "Total Sales" has the same meaning (i.e., the total revenue from sales), the same scale (e.g., in US dollars), and is calculated in the same way (e.g., quantity sold times unit price) in both fact tables.

Last updated