sithusithu

 Profile Answers by sithusithu 

• Jan 19th, 2006

 

A Router transformation is similar to a Filter transformation because both transformations allow you to use a condition to test data. A Filter transformation tests data for one condition and drops the rows of data that do not meet the condition. However, 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.

 

Cheers,

Sithu

Rksinghpathania

 Profile Answers by Rksinghpathania 

• Jun 27th, 2007

 

Note:- i think the definition and purpose of Router transformation define by sithusithu, sithu is not clear and not fully correct as they of have mentioned
<A Router transformation tests data for one or more conditions >
sorry sithu and sithusithu
but i want to clarify is that in Filter transformation also we can give so many conditions together. eg. empno=1234 and sal>25000 (2conditions)

Actual Purposes of Router Transformation are:-

1. Similar as filter transformation to sort the source data according to the condition applied.
2. When we want to load data into different target tables from same source but with different condition as per target tables requirement.
   e.g. From emp table ,we want to load data in three(3) different target tables T1(where deptno=10),    T2(where deptno=20) and T3(where deptno=30).
   For this, if we use filter transformation we need three(3) filter transformations,
   So instead of using  three(3) filter transformation we will use only one(1) Router transformation.

Advantages:-
     1. Better Performance because in mapping the Router transformation Informatica server processes the input  data only once instead of three as in filter transformation.
      2. Less complexity because we use only one router transformation instead of multiple filter transformation.

 Router Transformation is :- Active and Connected.