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

technology enterprise content management

  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

Show answer
Correct Option: B

Find more quizzes: