Scribd
Upload
17 views11 pages

Router Transformation in Informatica

The document describes how to use a router transformation in Informatica to split data from an EMP source table into three target tables, EMP_R1, EMP_R2, and EMP_R3, based on conditions. It also shows how to use a union transformation to combine data from the DEPT source table and Dept1.txt file into a single DEPT_UNION target table. The transformations are implemented in mappings and executed through workflows to load the target tables.

Uploaded by

Deepak Kumar
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
17 views11 pages

Router Transformation in Informatica

The document describes how to use a router transformation in Informatica to split data from an EMP source table into three target tables, EMP_R1, EMP_R2, and EMP_R3, based on conditions. It also shows how to use a union transformation to combine data from the DEPT source table and Dept1.txt file into a single DEPT_UNION target table. The transformations are implemented in mappings and executed through workflows to load the target tables.

Uploaded by

Deepak Kumar
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

INFORMATICA

ROUTER TRANSFORMATION

 Define source tables – EMP

 Define Target tables – EMP_R1,EMP_R2 & EMP_R3

1 [Link]@[Link]
99520 29030
INFORMATICA

 Create a New Mapping for m_emp_Router

2 [Link]@[Link]
99520 29030
INFORMATICA
 Drag and Drop all columns from SQ to Router

 Add a New group using Group Tab

3 [Link]@[Link]
99520 29030
INFORMATICA
 Apply the conditions

 Connect All the Groups to target tables

4 [Link]@[Link]
99520 29030
INFORMATICA
 Apply the connection value to all the target tables

 Create a workflow and exec using start workflow

5 [Link]@[Link]
99520 29030
INFORMATICA

 Validate the data using TOAD

6 [Link]@[Link]
99520 29030
INFORMATICA

7 [Link]@[Link]
99520 29030
INFORMATICA
UNION TRANSFORMATION
 Define source tables – DEPT and [Link]

 Define target tables – DEPT_UNION

8 [Link]@[Link]
99520 29030
INFORMATICA
 Create a New Mapping for m_emp_Router

 Drag the columns from SQ to UNION and target

9 [Link]@[Link]
99520 29030
INFORMATICA
 Add a new Group

 Connect all the columns from SQ to Union

10 [Link]@[Link]
99520 29030
INFORMATICA
 Create a workflow and exec using start workflow

 Validate the Target data using Toad

11 [Link]@[Link]
99520 29030

You might also like