Multiple choice technology

Which of the following is an example of a slowly changing dimension?

  1. Customer on a sales order

  2. Person responsible for a cost center

  3. Date

  4. Value of a Purchase Order

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

A slowly changing dimension (SCD) is a dimension whose attributes change gradually over time. The 'person responsible for a cost center' can change when responsibilities are reassigned, making it a classic SCD example. Dates don't change, and customer/order relationships or purchase order values aren't dimensions.