Interested to Buy Any Domain ? << Click Here >> for more details...
What is the Router transformation?
- 2 Answers
- 10469 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 |
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
Q. We are the loading the table on daily basis it is incremental loading. and A person rahul slary was 10000, so if i check before run my salalr is 10000. but toay there is update that my sal is 15k but that will come to know after the load. braod crtiteria is we donot want to show downstream teams partial updated data. need aproad as etl developer
i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .
By using joiner t/r we can join only 2 tables, SO if want join more than 2 flat files ,How can i join?
I have some rows in source.I have to map half rows to one target and half rows to another target.i.e you wont know how many records in source.?Implement a mapping?
how to join two flat files in informatica?
What is the difference between a connected look up and unconnected lookup?
Differentiate between router and filter transformation?
Which kind of index is preferred in DWH?
What is a predefined event?
How we can confirm all mappings in the repository simultaneously?
without using rank transformation how can we rank items by using some other transformations
Teradata 
