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.
it is differnt from filter transformation in which we can specify multiple conditions and route the data to multiple targets depending upon the condition.
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.
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.
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.
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.
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.
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.
