Ashfaque Sayed

• Jul 17th, 2005

 

Router transformation is use to load data in multiple targets depending on the test condition.

purushotham

• Aug 9th, 2005

 

it is differnt from filter transformation in which 
we can specify multiple conditions and route the data to multiple targets depending upon the condition.

Sireesh Babu

• Sep 13th, 2005

 

Router is diferent from filter, using filter we can test the incoming data by one condition by Router we can test incoming data with several conditions.And also we can not get the Data which is not satisfing filter condition if we use filter  but by using router we can get it in defalt group.   

MANOJ KUMAR

• Sep 13th, 2005

 

The best thing of using router transformation over filter transformation  is that we can get the rejected records if needed.

MANOJ KUMAR

• Sep 26th, 2005

 

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. Thus the added advantage over filter transformation is that we can also route rejected records as per requirement.

madhavi

• Oct 4th, 2005

 

Router transformation allows to test more than one condition and based on condition you can route the data into different targets or target instances.

ganesh

• Oct 15th, 2005

 

Router is an Active and Connected transformation. It is similar to filter transformation. But in filter transformation eliminate the data that do not meet the condition whereas router has an option to capture the data that do not meet the condition. It is useful to test multiple conditions. It has input, output and default groups. For example, if we want to filter data like where deptno=10, deptno=20, deptno=30 and all other deptno's. It?s easy to route data to different tables.

swati

• Nov 4th, 2005

 

It is an extension to filter transformation.It is used to rout the data to different destination according to the condition.It has one i/p group of ports & multiple groups of o/p ports.It is an active transformation.

sithusithu

 Profile Answers by sithusithu 

• Jan 23rd, 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

md_ahmedferoze

 Profile Answers by md_ahmedferoze 

• Jul 5th, 2007

 

Both Transformation Filter and Router used to test condition, but a Router can test multiple conditions.  If same source is to be test for multiple conditions then go for Router rather than using seperate Filters and read source data again and again.

siraj.khan

• Aug 3rd, 2007

 

Router Transformation is same as that of Filter Transformation.The only difference is that we can specify only one condion for filter but for Router we can specify many condition and one more thing the data which are not satisfying the filter conditions are stored in Default port of Router transformation.

suneel.kolamudi

 Profile Answers by suneel.kolamudi 

• Feb 3rd, 2009

 

Router Transfermation is used to test the same in put rows based on multiple conditions and if we want to load multiple targets, then we go for Router Transformation

Thanks & Regards
Suneel.Kolamudi

YugandharS

 Profile Answers by YugandharS Questions by YugandharS

• Jun 17th, 2010

 

Router transformation allows you to use a condition to test data. It is similar to filter transformation. It allows the testing to be done on one or more conditions.

pradeeshkumar

 Profile Answers by pradeeshkumar 

• Aug 19th, 2010

 

Router transformation can be said as an extension of filter transformation. Filter allows you to check for a single condition and rejects rows which does not meet the condition.
But Router transformation allows you to specify more than one condition and forward rows to target,
If it atleast meets any of the specified conditions.
Router has an additional option (default) for forwarding rejected rows to another target table.