Pro exercise

Resolve customers through a crosswalk

The shop and the CRM give the same customer different keys. A crosswalk maps every source key to one master customer ID. Resolve orders through it before totalling, or one customer's revenue is split across two keys.

entity resolution
lookups
aggregation