A data architect needs to create an app that combines employee data from the Sales system and the Human Resources (HR) system.
These systems identify employees differently Employees in the HR system are identified with an alpha-numeric key Employees in the Sales system are identified using an integer key.
The Human Resources manager creates a table that maps these keys to another, called Associations. The resultant data model must meet the following requirements:
· Associations must be valid
· The model must be optimized for performance
· The option must support multiple tables added
Which solution should the data architect use to meet these requirements?
- APPLYMAP ( 'Associations , EmployeeKey ) as Employeekey;
- MAPSUBSTRING ( 'Associations' ,EMployeekey) As Employeekey;
- MAP EmloyeeKey USING Associations;
- RENAME FIELDS USING Associations;
Answer(s): C
Explanation:
The MAP function maps the EmployeeKey in the Sales system to the EmployeeKey in the HR system using the Associations table. This allows the data architect to join the data from the Sales system and the HR system using the same key, ensuring that the associations are valid. Using the MAP function also optimizes the performance of the data model as it eliminates the need for multiple joins between the data from the Sales and HR systems. This solution also supports multiple tables added, as the MAP function can be applied to any table that needs to be joined with the HR system data.