Wednesday, July 16, 2008

35. INFORMATICA FAQ'S

SOURCE: 1. http://www.allinterview.com/showanswers/69154.html
SOURCE: 2. http://deviinformatica.blogspot.com/2007/09/informatica-interview-questions.html

Re: Differnce between filter and router?
Answer
# 1
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.

No comments: