What is the Router transformation?
- 2 Answers
- 8833 Views
- Informatica, I also Faced
- E-Mail Answers
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 |
After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?
After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can you map these three ports directly to target?
Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggriagator and one sq trans to an router transformation
In a table, 4 person having same salary. How to get Third person record only?
I have scenario, i have 10 worklflows and i want run the 1st workflow first and immediately i want to run 10th workflow has to run and am not bothering of 2 to 9 workflows? can any one help me how to do this? Thanks in advance.....
In informatica workflow manager, how many repositories can be created?
What is CHECK-IN CHECK-OUT. Please explane me?
explain different levels in pushdown optimization with example?
Define informatica repository?
Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?
What is reconstalation n What is fact constalation? Correct me if i m wrong in the question.
How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.
Teradata 
