Answer Posted / ashish a
first the Similarity between Router and Filter is
-Both transformation would able to discard data based on
some filter condition.
The Differences are...
1.Using router transformation one would able to test
incoming data for multiple filter condition and if none of
the condition met the incoming rows gets reouted to DAFAULT
group.
2.Using filter transformation one would able to pass data
to next transformation based on single filter pipeline
condition.There is no option of routing data that doesnt
match the condition like ROUTER Transformation.
| Is This Answer Correct ? | 38 Yes | 3 No |
Post New Answer View All Answers
What is the Rank index port in Rank transformation?
Explain the mapping variable usage example in informatica
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
How might one distinguish in the case of mapping is right or not without associating session?
How to create Target definition for flat files?
what is the size of u r source(like file or table)?
Can we create a Integration service without a Repository service and vice versa?
What is meant by LDAP users?
What is rank transform?
What are the performance considerations when working with aggregator transformation?
Describe expression transformation?
Plz can any one say me how to get the informatica certification materials and dumps
What are the various types of transformation?
How to partition the Session?
What does update strategy mean, and what are the different option of it?
