A slowly changing customer dimension must preserve the region applicable when each sale occurred. Which modeling approach fits?

Published
  1. Type 2 versions with effective dates and surrogate keys
  2. Store region only in a report title
  3. Overwrite every historical region in one row
  4. Join every sale to every customer version

Comments — 0