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
Enlist the differences between database and data warehouse.
I need the output file in the below format using Informatica. __0946684800__ 6 1 3 1 5 1 6 1 10 1 6 10 Pos State Time Split AgentID Reason Spaces Code in Code Spare state ______ ___ _____ ______ __________ ______ 1234 14 0 4321 3103 abcd 4321 15 5 123452 3150 Can someone help please?? We need the data in space-delimited, fixed ASCII format .
What are the different clients of powercenter?
is it possible to index the data in cache of lkp transformation ?
Define mapping and session?
What is the use of target designer?
What is meant by a domain?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What all are steps in up gradation of Informatica server?
Differentiate between router and filter transformation?
What are the types of caches in lookup?
What is a filter transformation and why it is an active one?
Define pmcmd command?
What are the static cache and dynamic cache in informatica?
Define mapplet?