Fact Table
Type of Fact-
1-Additive- Additive facts are facts that can be summed through all of the dimensions in the fact table.
2-Semi-Additive- Semi-aditive facts are that can be summed through some of the dimensions and cannot be summed through some dimensions.
3-Non-Additive- Non-additive facts are that can not be summed up for any dimensions in fact table
Factless Fact table-
A factless table is fact table which does not contains any measure. It is just an intersection of dimenstions.
