What is the Router transformation?
Answers were Sorted based on User's Feedback
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 |
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 |
How can we update a record in the target table without using update strategy?
What is the Difference between DSS & OLTP?
one source to target loading insert new rows and update existing rows?
Briefly define reusable transformation?
Define mapplet?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What are steps to follow Informatica migration from 7x to 8x? Pls Explain...
explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???
What is an expression transformation?
what are the deliverables?in your project?
In informatica workflow manager, how many repositories can be created?
How to join three sources using joiner?