84. A source field changes from an integer code to a text label. What controls should prevent a silent reporting error?
EasyAnalysis & visualization
Technical
Show model answer
Validate the schema and allowed semantics at ingestion rather than accepting any value that can be coerced. A type-compatible conversion can still alter the meaning of a category or create unexpected missing values.
Stop or quarantine affected records according to the pipeline contract, notify the accountable owner and review the mapping. Reconcile counts before releasing the corrected dataset, and retain examples that test the changed representation.
What interviewers listen for
- Validate semantics as well as types
- Quarantine or stop according to contract
- Reconcile the reviewed mapping