An analytical dimension must preserve historical attribute values with effective periods instead of overwriting each change. Which pattern fits?

Published
  1. Slowly changing dimension Type 2
  2. SCD Type 1 only
  3. Drop the table after each update
  4. Keep only the latest file name

Comments — 0