This website uses cookies to ensure you get the best experience.
Learn more.
A slowly changing customer dimension must preserve the region applicable when each sale occurred. Which modeling approach fits?
Published
- Type 2 versions with effective dates and surrogate keys
- Store region only in a report title
- Overwrite every historical region in one row
- Join every sale to every customer version
Comments — 0
Sign in to comment