Skip to interview prep
Apexed

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
A source field changes from an integer code to a text label. What controls should prevent a silent reporting error — Data & analytics interview question — Apexe