Tuesday, December 25, 2012

Router transformation



What is the Router transformation?

A Router transformation is an Active and Connected transformation. It similar to a filter transformation as it is also used to filter the data. Router transformation is used to can create multiple filter conditions on the same input data but filter condition can have only oe filter on input data. A Router transformation can also capture the rejected records.





Check the above example I have filtered the data based on department number. The input source is filtered and transferred to 3 different output tables. The first output(Dept_10) consists the data for department number 10.  The second output(Dept_20) consists the data for department number 20 and the third output(Dept_except_10and20) consists the rejected records. 





From above image you can see that we can create multiple filters on the same input data. To implement this using filter you need to have three sources and three filter transformations. If you need to test the same input data based on multiple conditions, use a Router transformation in a mapping instead of creating multiple Filter transformations to perform the same task.

For sample exercise on this transformation check this http://prashanthobiee.blogspot.com/2012/12/exercise-to-implement-router.html



2 comments:

  1. Really nice blog post.provided a helpful information.I hope that you will post more updates like this Informatica Online Course Hyderabad

    ReplyDelete

Related Posts Plugin for WordPress, Blogger...