Fact-less fact table in a data warehouse contains
2014
Fact-less fact table in a data warehouse contains
- A.
only measures
- B.
only dimensions
- C.
keys and measures
- D.
only surrogate keys
Attempted by 45 students.
Show answer & explanation
Correct answer: B
Answer: A fact-less fact table contains only foreign key columns referencing dimension tables and no numeric measures.
Definition: A fact table that does not include measurable facts (numeric measures) and contains only keys to dimensions.
Purpose: To record events, coverage, or many-to-many relationships between dimensions (for example, student attendance, course enrollments, or promotion eligibilities) without storing measures.
Typical structure: Only foreign key columns (often surrogate keys) that reference dimension tables; no fact/measure columns.
Example: An attendance factless table might have student_key, date_key, class_key to record attendance events, but no numeric measures like quantity or amount.