CleanDims

05 / Maintain

Ambiguous values go to a person.

Ambiguous values go to a person. Decisions become aliases.

Example

Incoming valueDecisionStatus
AWSAmazon Web Servicesknown alias
AmazonWhich product?needs review
New YorkState 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.