[ EASY ]
Map a client's CRM fields to a warehouse schema
Quick answer
Brief: A client exports CRM contacts and deals with free-text fields, optional owners and duplicate emails. Design the warehouse tables that will hold them.
Tasks
- 1. List the entities and their keys
- 2. Decide how to handle duplicate contacts
- 3. Write the DDL and one query that proves it works
Show hints
- → Start from the questions the client's analysts ask, not from the CRM's field list
- → Keep the raw export untouched in a staging table
Skills