What is the Router transformation?

Answers were Sorted based on User's Feedback



What is the Router transformation?..

Answer / swetha

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

Is This Answer Correct ?    19 Yes 1 No

What is the Router transformation?..

Answer / manjunath

Router transformation is a active and connected transformation,
It is used to test multiple conditions in which it has two groups 1.Input group 2. output group . In router transformation
rejected rows will be sent to default group where we dont have in filter t/f. Router t/f is connected to multiple targets.

Let me know if iam wrong

Is This Answer Correct ?    5 Yes 4 No

Post New Answer

More Informatica Interview Questions

Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?

0 Answers  


What is informatica worklet?

0 Answers  


What is deployemnt groups, Lables, query and dynamic deployment group.

1 Answers   IBM, SVP,


Hi, What is version control in Informatia ? Can anyone just give an idea or introduction about this? Advance Thanks

2 Answers   IBM,


Have you worked with/created Parameter file

0 Answers  






 Code page compatibly –Where all changes are made to handle the scenario.

1 Answers   DELL,


What are the mapping paramaters and mapping variables?

1 Answers  


What are 2 modes of data movement in Informatica Server?

1 Answers   Informatica,


get me output as if input is like 1 x o/p-->1 x,y,z 1 y 2 a,b 1 z 3 c 2 a 2 b 3 c

0 Answers   Infosys,


What happens if the info. Server doesn't find the session parameter in the parameter file?

1 Answers  


what is degenerated dimension?

1 Answers   IBM,


insallation procedure for power center 8.1.1 especialy domain_config hw to use parameter files

1 Answers  


Categories