15. How would you specify a mapping from legacy customer status codes to a new system?
MediumData & validation
Technical
Show model answer
List each source value and meaning, the target value, transformation rules, and the owner who approved them. Include blank, invalid, obsolete, and many-to-one cases instead of mapping only the common codes.
Agree reconciliation totals, representative fictional examples, and an exception process. Test whether the mapping loses distinctions needed for operations or reporting before approving a bulk migration.
What interviewers listen for
- Explicit value mappings
- Handle exceptions
- Check information loss