In the following steps, you create a mapping to transform the employee data. You add the following objects to the mapping:

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.