✍ Kashif M
Trends

Sunday, 7 July 2013


Router transformation in Informatica


By on July 07, 2013


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.


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. The Router transformation is more efficient when you design a mapping and when you run a session. For example, to test data based on three conditions, you only need one Router transformation instead of three filter transformations to perform this task. Likewise, when you use a Router transformation in a mapping, the Informatica Server processes the incoming data only once. When you use multiple Filter transformations in a mapping, the Informatica Server processes the incoming data for each transformation. 

Kashif
mkashu: Router transformation in Informatica
Review : Kashif | Kashif
Update: July 07, 2013 | Rating: 4.5

Comment for "Router transformation in Informatica"

0 comments

Post a Comment

Blog Archive