On executing a load script of an app, the country field needsto be normalized.The developer uses a mapping table to address the issue.
What should the data architect do?
Use a LEFT JOIN instead of the APPLYMAP
Use LOAD DISTINCT on the mapping table
Create two different mapping tables
Review the values of the source mapping table
Submit