Types of Fact Tables
Additive
Additive, Semi-Additive, and Non-Additive Facts The numeric measures in a fact table fall into three categories. The most flexible and useful facts are fully additive; additive measures can be summed across any of the dimensions associated with the fact table.
source:
kimballgroup.com
image:
slideplayer.com
Semi-Additive
Additive, Semi-Additive, and Non-Additive Facts The numeric measures in a fact table fall into three categories. The most flexible and useful facts are fully additive; additive measures can be summed across any of the dimensions associated with the fact table.
source:
kimballgroup.com
image:
dba.stackexchange.com