Multiple choice technology enterprise content management

How does one store history information of a dimension that is likely to change over time?

  1. Store the business Id of the dimension in the fact table, when the dimension is updated, update the dimension

  2. Add surrogate keys in the dimension and fact, create a new row in the dimension when it is updated

  3. Create a new dimension table

  4. Add another column to the dimension table to store the update
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

To preserve historical changes in a dimension (Slowly Changing Dimension Type 2), you add surrogate keys to the dimension and fact tables, and insert a new row in the dimension table whenever an update occurs.

Keep practicing — related questions