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 unit testing?tell me proceedure
How might you approve all mappings in the archive all the while?
What is transformation?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What are the restrictions of union transformation?
What is joiner transformation?
What is domain in terms of informatica?
What is target designer and target load order?
What are the different types of olap? Give an example?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is target load order?
Why filter transformation is an active one?
What is joiner transformation in informatica?
How does the aggregator transformation handle null values?
How will the document be delivered to me?