What is Router Transformation?
Switch change is a functioning and associated change which is like channel change used to channel the source information.
The extra usefulness given adjacent to separating is that the disposed of information (sifted through information) can likewise be gathered in the planning, as well as the different channel conditions can be applied to get numerous arrangements of information.
For instance, while separating the information structure deptno =10, we can likewise get those records where deptno isn't equivalent to 10. In this way, switch change gives numerous result gatherings, and each result gathering can have its own channel condition.
Likewise, there is likewise a default bunch, this default bunch has those record sets which doesn't fulfill any of the gathering conditions. For instance, on the off chance that you have made two gatherings for the channel conditions deptno=10 and dept=20 individually, then, at that point, those records which do not have deptno 10 and 20 will be passed into this default bunch. In short, the information which is dismissed by the channel gatherings will be gathered by this default bunch and at times there can be a necessity to store this dismissed information. In such situations, default yield gathering can be valuable.
In the complex landscape of data transformation and routing,
the Router Transformation in Informatica stands as a powerful tool. It allows
data professionals to direct data rows precisely based on defined conditions,
ensuring that data flows seamlessly through the transformation process. In this
article, we'll explore the significance, functionality, and practical
applications of the Router Transformation in Informatica.
Understanding the Router Transformation
What is the Router Transformation?
The Router Transformation is a fundamental component within
Informatica PowerCenter. Its primary function is to segregate data rows into
multiple groups or "routes" based on specified conditions. Each
condition defines a set of rules that determine which route a data row will
follow.
Key Functions of Router Transformation
The Router Transformation offers several key functions:
Configuration and Usage
Configuration Steps
To configure the Router Transformation effectively, follow
these steps:
1. Create
Ports: Define input and output ports for the Router Transformation. Input
ports receive data rows, and output ports represent the different routes.
2. Define
Conditions: For each output port, define conditions using expressions.
These conditions determine which data rows are directed to each route.
Practical Applications
The Router Transformation is versatile and finds
applications in various scenarios:
Performance Considerations
Efficiency is crucial when working with the Router
Transformation:
To permit numerous channel conditions, the switch change gives a bunch of choices.
There is a default input bunch that takes input information
There is likewise a default yield bunch which gives that large number of information that isn't passed by any channel condition
For each channel condition, a result bunch is made in switch change. You can associate various focuses to these various gatherings.
Making Router Transformation
Stage 1 - Create planning having source "EMP" and target "EMP_TARGET."
Switch Transformation in Informatica with EXAMPLE
Stage 2 - Then in the planning
Select Transformation menu
Select make choice
Switch Transformation in Informatica with EXAMPLE
Stage 3 - In the make change window
Select switch change
Enter a name for the change "rtr_deptno_10"
Select Create choice
Stage 4 - The switch change will be made in the planning, select done choice in the window
Click here for details |
Switch Transformation in Informatica with EXAMPLE
Stage 5 - Drag and drop every one of the sections from the Source qualifier to switch change
Switch Transformation in Informatica with EXAMPLE
Stage 6 - Double snap on the switch change, then, at that point, in the change property of it
Select gathering tab
Enter bunch name "deptno_20"
Click on the gathering channel condition
Switch Transformation in Informatica with EXAMPLE
Stage 7 - In the articulation supervisor, enter channel condition deptno=20 and select the OK button.
Switch Transformation in Informatica with EXAMPLE
Stage 8 - Select the OK button in the gathering window
Switch Transformation in Informatica with EXAMPLE
Stage 9 - Connect the ports from the gathering deptno_20 of switch change to target table ports
Switch Transformation in Informatica with EXAMPLE
Presently, when you execute this planning, the separated records will get stacked into the objective table.
Source Qualifier Transformation in Informatica |
Introduction to Transformations in Informatica and Filter Transformation |
Session Objects in Informatica |
How to Debug Mappings in Informatica |