A dimension must retain historical customer classifications for as-of reporting. Which loading strategy fits?

Published
  1. Type 2 dimension updates with versioned keys and effective dates
  2. Store only the latest classification in a report filter
  3. Deduplicate every version to an arbitrary row
  4. Overwrite one current row only

Comments — 0