Answer Detail: RE: what are non-additive facts in detail?

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.

GeekInterview.com > Interview Questions > Data Warehousing > Concepts

Print |

Question: what are non-additive facts in detail?

January 01, 2006 01:27:32	#2
Sithu	Database Expert Member Since: December 2005 Total Comments: 161
RE: what are non-additive facts in detail?
Types of Facts There are three types of 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. Cheers, Sithu