Master Data Golden Record & Dedup Ruleset

Act as a master data management (MDM) expert. Help me design a golden-record ruleset to deduplicate my [customer / vendor / product] master. Fields available: [e.g. name, tax ID, email, address, phone, account #] Known data issues: [duplicates, typos, abbreviations, missing IDs] System of record: [ERP/CRM name] Match tolerance: [strict / fuzzy acceptable] Please: 1. Propose deterministic match rules (exact keys like tax ID) and fuzzy match rules (name + address similarity) with suggested thresholds 2. Define survivorship rules: for each field, which source/record wins (most recent, most complete, trusted source) 3. Describe how to build a golden record and keep cross-references to the merged source IDs 4. Give a tiered confidence model (auto-merge / review queue / no-match) and what % to expect in each 5. List the data quality checks to run before and after, and the metrics to report (duplicate rate, match rate, completeness)