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 |
What is informatica?
How many types of sessions are there in informatica.please explain them?
sorce is a flatfile only 1st and last row should insert to target how will u do?
How can you differentiate between powercenter and power map?
Can you start a session inside a batch individually?
How to display First letter of Names in Caps?
HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND REMAINING TO OTHER TARGET?
How many repositories can we create in Informatica?
my table contain duplicate Records i wanna load uniq records to my table . i have to pass the uniq records through filter t/r how?
i have source as Column1 101 a 101 b 101 c so i want to load target as column1 ---> 101 abc
The question was on time stamp. what is the difference between HH and HH24 when to use when.
Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin