| |
GeekInterview.com > Interview Questions > Data Warehousing > Concepts
| Print | |
Question: What are non-additive facts?
|
| August 08, 2005 15:13:20 |
#3 |
| Praveen |
Member Since: Visitor Total Comments: N/A |
RE: What are non-additive facts?
|
# Additive: Additive facts are facts that can be summed up through all of the dimensions in the fact table.
# 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.
# Non-Additive: Non-additive facts are facts that cannot be summed up for any of the dimensions present in the fact table. |
| |
Back To Question | |
