| |
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:45:54 |
#2 |
| 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
|
A factless fact table captures the many-to-many relationships between
dimensions, but contains no numeric or textual facts. They are often used to record events or
coverage information. Common examples of factless fact tables include:
- Identifying product promotion events (to determine promoted products that didn’t sell)
- Tracking student attendance or registration events
- Tracking insurance-related accident events
- Identifying building, facility, and equipment schedules for a hospital or university |
| |
Back To Question | |
