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
Briefly define a session task?
How do you migrate data from one environment to another?
What is source qualifier transformation in informatica?
What is decode in informatica?
can anyone suggest best free Talend data integration training online
Where are the source flat files kept before running the session?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
What is the format of informatica objects in a repository?
Explain the use of aggregator cache file?
How to implement security measures using repository manager?
What are the mapping parameters and mapping variables?
Explain in detail scd type 2 through mapping.
What is workflow monitor?
what is informatica metadata?
Different sorts of metadata that stores in the storage facility?