Multiple choice technology

Slowly Changing- Type 2

  1. No history is maintained

  2. The key gets updated with the changed attributes

  3. History maintained

  4. new or prior attribute values
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Slowly Changing Dimension Type 2 maintains complete historical data by adding a new row for each change rather than updating existing records. Each version includes effective date and expiry date columns (or current record flag) to track when the attribute value was valid, enabling full historical analysis and trend identification.

Keep practicing — related questions