Informatica
Mappings in Informatica: Create, Components, Parameter, Variable
What is a Mapping? Mapping is a collection of source and target objects linked together by a set of...
Router transformation is an active and connected transformation which is similar to filter transformation, used to filter the source data.
The additional functionality provided beside filtering is that the discarded data (filtered out data) can also be collected in the mapping, as well as the multiple filter conditions can be applied to get multiple sets of data.
For example, when filtering the data form deptno =10, we can also get those records where deptno is not equal to 10. So, router transformation gives multiple output groups, and each output group can have its own filter condition.
In addition there is also a default group, this default group has those record sets which doesn't satisfy any of the group conditions. For example, if you have created two groups for the filter conditions deptno=10 & dept=20 respectively, then those records which are not having deptno 10 and 20 will be passed into this default group. In short the data which is rejected by the filter groups will be collected by this default group and sometimes there can be a requirement to store these rejected data. In such scenarios, default output group can be useful.
To allow multiple filter condition, the router transformation provides group option.
Creating Router Transformation
Step 1 – Create a mapping having source "EMP" and target "EMP_TARGET."
Step 2 – Then in the mapping
Step 3 – In the create transformation window
Step 4 – The router transformation will be created in the mapping, select done option in the window
Step 5 – Drag and drop all the columns from Source qualifier to router transformation
Step 6 – Double click on the router transformation, then in the transformation property of it
Step 7 – In the expression editor, enter filter condition deptno=20 and select OK button.
Step 8 – Select OK button in the group window
Step 9 – Connect the ports from the group deptno_20 of router transformation to target table ports
Now, when you execute this mapping, the filtered records will get loaded into the target table.
What is a Mapping? Mapping is a collection of source and target objects linked together by a set of...
Joiner Transformation - Always prefer to perform joins in the database if possible, as database...
As we discussed in previous topics, a mapping is a collection of source and target objects linked...
After installing Informatica server and client, Informatica server needs to be configured. The...
What is Sequence Generator Transformation? Sequence generator transformation is passive so it does...
$20.20 $9.99 for today 4.5 (125 ratings) Key Highlights of Informatica Tutorial PDF 234+ pages...