A customer dimension must retain previous attribute values with validity periods. Which AUTO CDC strategy fits?

Published
  1. Overwrite the whole table with the newest arriving event
  2. SCD Type 2
  3. SCD Type 1
  4. Append every event without a sequencing key

Comments — 0