An e-commerce company wants to track changes in customer addresses but doesn't want to retain the history of previous addresses. What type of SCD should be implemented?

  • SCD Type 1
  • SCD Type 2
  • SCD Type 3
  • SCD Type 4
To track changes in customer addresses without retaining the history of previous addresses, you should implement SCD Type 1. This type overwrites existing data with the new address information, ensuring that only the most recent data is retained. SCD Type 2, 3, and 4 involve preserving historical data, which is not necessary in this scenario.
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *