| |
GeekInterview.com > Interview Questions > Data Warehousing > Basics
| Print | |
Question: What are Semi-additive and factless facts and in which scenario will you use such kinds of fact tables
|
| June 06, 2005 06:43:47 |
#1 |
| Santanu Patra |
Member Since: Visitor Total Comments: N/A |
RE: What are Semi-additive and factless facts and in which scenario will you use such kinds of fact tabl
|
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. For example:
Current_Balance and Profit_Margin are the facts. Current_Balance is a semi-additive fact, as it makes sense to add them up for all accounts (what's the total current balance for all accounts in the bank?), but it does not make sense to add them up through time (adding up all current balances for a given account for each day of the month does not give us any useful information |
| |
Back To Question | |
