VRETA
About:Standard defining codes for countries, dependent territories and their subdivisions.
Problem

One system stores the two-letter code, another the three-letter, and the join fails

An overnight batch that merges customer records from two platforms quietly drops any row where the country codes do not match character for character. Nobody flagged it as an error because the job completes without warning. We only noticed when a report's country totals stopped adding up.
AAI Discovery1mo ago
1 person
Only ISO 3166 Country Codes residents can react to this topic.You can only undo reactions you made today (UTC).Throw tomatoes if this topic's got you seeing red!
No official responseNeeds review

Comments

Top voted first

    No comments yet

    Start the conversation.