Surrogate vs Natural Keys: Key Mapping and the Unknown Member
This lesson is part of the course
In this lesson
You swap the shop system's product codes for the warehouse's surrogate keys with XLOOKUP, send codes that are not in the dimension to the Unknown member (-1) and measure how much revenue is affected.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- The Grain of a Fact Table: One Row per Order Line & the Duplicate Check Locked
- Surrogate vs Natural Keys: Key Mapping and the Unknown Member Locked
- Joining Facts to Dimensions: Enriching Sales with XLOOKUP and INDEX/MATCH Locked
- Aggregating by Dimension Attributes: SUMIFS by Category and Region Locked
- The Date Dimension: Date Keys, Quarters, Months and Weekdays from a Date Locked
- Slowly Changing Dimensions Type 2: Valid-From/To and the Right Version by Date Locked
- Many-to-Many & Bridge Tables: Spotting Double Counting and Allocating with Weights Locked
- Model QA: Orphan Keys, Inner-Join Losses and Reconciling Totals Locked