Facts are also known as "Measures". These facts are used to measure the business values and forecast business future.
The different types of facts are
Additive facts : The facts that can be summed up through all the dimension in the fact table. Sales fact is the good example for additive fact.
Semi additive facts : The facts that can be summed up through some of the dimensions in the fact table. Daily balance is the perfect example of semi additive fact.
Non additive facts : The facts that cannot be summed up through any of the dimensions in the fact table. Percentage and ratios are the perfect example of non additive fact.
Factless Fact : A table which does not contain measures or facts are called as factless fact. Product key and Date key is the perfect example of factless fact.
The different types of facts are
Additive facts : The facts that can be summed up through all the dimension in the fact table. Sales fact is the good example for additive fact.
Semi additive facts : The facts that can be summed up through some of the dimensions in the fact table. Daily balance is the perfect example of semi additive fact.
Non additive facts : The facts that cannot be summed up through any of the dimensions in the fact table. Percentage and ratios are the perfect example of non additive fact.
Factless Fact : A table which does not contain measures or facts are called as factless fact. Product key and Date key is the perfect example of factless fact.
No comments:
Post a Comment