Getting Started

Back Next

Completing the Mapping

Connect the Router transformations to the targets to complete the mapping.

Connect the ports from RTR_Salary groups to the ports in the XML target definitions.

The following table describes the ports in RTR_Salary groups and the ports in the XML target definitions:

Router Group	Router Port	Target	Target Group	Target Port
Sales	EMPID1	SALES_SALARY	EMPLOYEE	EMPID
Sales	DEPTID1	SALES_SALARY	EMPLOYEE	DEPTID (FK)
Sales	LASTNAME1	SALES_SALARY	EMPLOYEE	LASTNAME
Sales	FIRSTNAME1	SALES_SALARY	EMPLOYEE	FIRSTNAME
Sales	TotalSalary	SALES_SALARY	EMPLOYEE	TOTALSALARY
Engineering	EMPID3	ENG_SALARY	EMPLOYEE	EMPID
Engineering	DEPTID3	ENG_SALARY	EMPLOYEE	DEPTID (FK)
Engineering	LASTNAME3	ENG_SALARY	EMPLOYEE	LASTNAME
Engineering	FIRSTNAME3	ENG_SALARY	EMPLOYEE	FIRSTNAME
Engineering	TotalSalary3	ENG_SALARY	EMPLOYEE	TOTALSALARY

The following figure shows the Router transformation connected to the target definitions:

Connect the ports from RTR_DeptName groups to the ports in the XML target definitions.

The following table describes the ports in RTR_DeptName and the ports in XML target definitions:

Router Group	Router Port	Target	Target Group	Target Port
Sales	DEPTID1	SALES_SALARY	DEPARTMENT	DEPTID
Sales	DEPTNAME1	SALES_SALARY	DEPARTMENT	DEPTNAME
Engineering	DEPTID3	ENG_SALARY	DEPARTMENT	DEPTID
Engineering	DEPTNAME3	ENG_SALARY	DEPARTMENT	DEPTNAME

Click

Repository

Save

The mapping is now complete. When you save the mapping, the Designer displays a message that the mapping m_EmployeeSalary is valid.