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
How we can create indexes after completing the loan process?
Explain the types of transformations?
What are the advantages of using informatica as an etl tool over teradata?
Differences between version 7.x and 8.x.
Could you explain what is enterprise data warehouse?
What is expression transformation?
generate date / time dimension in informatica
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is meant by pre and post session shell command?
What is target designer and target load order?
what is unit testing?tell me proceedure
What is the different lookup cache(s)?
How do you load only null records into target? Explain through mapping flow.
As union transformation gives UNION ALL output, how you will get the UNION output?
