Which of the following table contains the primary information in the data…
2025
Which of the following table contains the primary information in the data warehouse?
- A.
Dimension table
- B.
Fact table
- C.
Lookup table
- D.
Primary table
Attempted by 78 students.
Show answer & explanation
Correct answer: B
Answer: Fact table contains the primary information in a data warehouse.
Key idea: Fact tables hold measurable, quantitative data (measures) about business processes and link to descriptive tables via foreign keys.
Contains measures such as sales amount, quantity, or transaction counts — the numeric metrics you aggregate.
Has a defined grain (for example, one row per sales transaction line), which determines the level of detail for analysis.
Includes foreign keys to dimension tables (customer, product, time) that provide descriptive context for those measures.
Serves as the primary source for reporting, aggregations, and analytics.
Why other table types are not the primary source:
Dimension tables store descriptive attributes (who, what, when, where) used to explain or filter measures, not the measures themselves.
Lookup tables are small reference or mapping tables and do not contain the central quantitative data used for analysis.
'Primary table' is not a standard data-warehousing term and is ambiguous; use the fact/dimension distinction instead.
A video solution is available for this question — log in and enroll to watch it.