Multiple choice technology

Which of the following is the most likely candidate for a ‘Fact’?

  1. Customer Name

  2. Number of overtime hrs

  3. ZIP Code

  4. Product

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

A Fact in data warehousing must be numeric, additive, and represent a measurement. 'Number of overtime hrs' is quantitative and can be aggregated (summed) across dimensions. Customer Name, ZIP Code, and Product are descriptive attributes that belong in dimension tables, not facts.