Getting Started

10.5.1
- 10.5
- 10.4.0

Back Next

Routing Employee Salary Data

Create a Router transformation and name it RTR_Salary. Then click

Done

In the Expression transformation, select the following columns and drag them to RTR_Salary:

EmpID

DeptID

LastName

FirstName

TotalSalary

The Designer creates an input group and adds the columns you drag from the Expression transformation.

Open the RTR_Salary Router transformation and select the

Groups

tab.

The

Edit Transformations

dialog box appears, with RTR_SALARY listed in the Select Transformation field.

On the

Groups

tab, add two groups.

Change the group names and set the filter conditions.

The following table describes the groups names and the filter conditions:

Group Name	Filter Condition
Sales	DEPTID = ‘SLS’
Engineering	DEPTID = ‘ENG’

The Designer adds a default group to the list of groups. All rows that do not meet the condition you specify in the group filter condition are routed to the default group. If you do not connect the default group, the Integration Service drops the rows.

Click

to close the transformation.

In the workspace, expand the RTR_Salary Router transformation to see all groups and ports.

Click

Repository

Save

Next, you create another Router transformation to filter the Sales and Engineering department data from the DEPARTMENT relational source.

Rename Saved Search

Table of Contents

Getting Started

Getting Started

Routing Employee Salary Data

Routing Employee Salary Data