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 blocking 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 types of presistent cache in look up tr.
What is the difference between informatica 7.0 and 8.0?
Have you worked with/created Parameter file
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Describe an informatica powercenter?
What is joiner transformation in informatica?
What is primary and backup node?
Write the prerequisite tasks to achieve the session partition?
Separate from an archive server and a powerhouse?
Enlist the differences between database and data warehouse.
How can we store previous session logs?
Scheduling properties,whats the default (sequential)
Slowly changing dimensions, types and where will you use them