level 1 Exam activity 4 mapping the data source
What should I do when I encounter a situation where three sources need to be mapped simultaneously?
Answers
-
Hi there, within each import action you will be asked to mapped each dimension of a module (target) to an element within the file or a fixed value (aka source). In this example, the module has three dimensions/targets: departments, roles, and line items.
The mapping for the first 2 targets appear correct, the third you will need to update to map to the line items to the "Drivers" column. Once complete, open the tab labeled "EMP03 Employee Drivers by Role Line Items" you can then review how each driver in the file maps to a line item in the module. Note you have titled a line item as "Bonus %" whereas the file lists it as "Bonus Percentage", thus the you may need to manually map those items together.
0
