32 / 94
Different types of facts.
Type of facts are:
Additive: Additive facts are facts that can be summed up through all of the
dimensions in the fact table. A sales fact is a good example for
additive fact.
Semi-Additive:Semi-additive facts are facts that can be summed up for some of the dimensions in the fact table, but not the others.
Eg: Daily balances fact can be summed up through the customers dimension but not through the time dimension.
Non-Additive:
Non-additive facts are facts that cannot be summed up for any of the dimensions present in the fact table.
Eg: Facts which have percentages, ratios calculated.
Asked In ::
Pintu Kumar
23 Feb, 2019 5:07 AM
Type of facts are:
Additive: Additive facts are facts that can be summed up through all of the
dimensions in the fact table. A sales fact is a good example for
additive fact.
Semi-Additive:Semi-additive facts are facts that can be summed up for some of the dimensions in the fact table, but not the others.
Eg: Daily balances fact can be summed up through the customers dimension but not through the time dimension.
Non-Additive:
Non-additive facts are facts that cannot be summed up for any of the dimensions present in the fact table.
Eg: Facts which have percentages, ratios calculated.