Preface
Product Overview
Before You Begin
Tutorial Lesson 1
Tutorial Lesson 2
- Creating Source Definitions
  - Viewing Source Definitions
- Creating Target Definitions and Target Tables
  - Creating Target Definitions
  - Creating Target Tables
Tutorial Lesson 3
Tutorial Lesson 4
Tutorial Lesson 5
- Creating a Mapping with Fact and Dimension Tables
- Creating a Workflow
Tutorial Lesson 6
Appendix A: Naming Conventions
- Suggested Naming Conventions
  - Naming Convention
Appendix B: Glossary
- PowerCenter Glossary of Terms

Getting Started

10.5
- 10.5.6
- 10.5.1
- 10.4.0

Back Next

Creating Router Transformations

A Router transformation tests data for one or more conditions and gives you the option to route rows of data that do not meet any of the conditions to a default output group.

In the following steps, you add two Router transformations to the mapping, one for each department. In each Router transformation you create two groups. One group returns True for rows where the DeptID column contains ‘SLS’. The other group returns True where the DeptID column contains ‘ENG’. All rows that do not meet either condition go into the default group.

Creating a Mapping with XML Sources and Targets

Routing Employee Salary Data

Routing Department Data

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal