Additive, Semi-Additive, Non-Additive | Data Warehousing
Additive, Semi-Additive, Non-Additive. In data warehousing, a fact table contains measurements or facts, which can be categorized into three types: additive, semi-additive, and non-additive. Additive Fact: Additive facts can be summed up across all dimensions of the fact table. For example, sales or revenue can be summed up by any dimension