Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
What is joiner transformation in informatica?
What is different between the data warehouse and data mart?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
What are the transformations that are not supported in mapplet?
What is the need of an ETL tool?
What is meant by lookup transformation?
What is the format of informatica objects in a repository?
Explain load alternative records / rows into multiple targets - informatica
Describe the impact of several join conditions and join order in a joiner transformation?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What is a passive transformation?
What is informatica metadata and where is it stored?
Differentiate between Load Manager and DTM?
What are batches?
Can you generate sequence numbers without using the sequence generator transformation?
