Two instances of the SALES_SALARY target definition you created.
An Expression transformation to calculate the total salary for each employee.
Two Router transformations to route salary and department.
You pass the data from the Employees source through the Expression and Router transformations before sending it to two target instances. You also pass data from the relational table through another Router transformation to add the department names to the targets. You need data for the sales and engineering departments.
In the Designer, switch to the Mapping Designer and create a mapping.
Name the mapping m_EmployeeSalary.
Drag the Employees XML source definition into the mapping.
Drag the DEPARTMENT relational source definition into the mapping.
By default, the Designer creates a source qualifier for each source.
Drag the SALES_SALARY target definition into the mapping two times.
Rename the second instance of SALES_SALARY as ENG_SALARY.
The Designer displays a warning that the mapping m_EmployeeSalary is not valid because you have not completed the mapping.
Next, you add an Expression transformation and two Router transformations. Then, you connect the source definitions to the Expression transformation. You connect the pipeline to the Router transformations and then to the two target definitions.