05 / Maintain
Ambiguous values go to a person.
Ambiguous values go to a person. Decisions become aliases.
Example
| Incoming value | Decision | Status |
|---|---|---|
| AWS | Amazon Web Services | known alias |
| Amazon | Which product? | needs review |
| New York | State or city? | needs review |
Use it when new values, new columns or drift would break an existing join.
Confidence scores and review.
Every mapping carries a confidence score. Uncertain ones wait for review, and each decision is reused.
Monitor.
New values, new columns, drift. New values are re-collated and pass through the same review. A grouping below the threshold waits for a reviewer.