Home > Software > Data-Warehouse > Informatica
Interview Questions   Tutorials   Discussions   Programs   

Informatica - What are the similarities/differences between ROUTER and FILTER?




553
views
asked SRVMTrainings December 18, 2011 06:18 AM  

What are the similarities/differences between ROUTER and FILTER?


           

1 Answers



 
answered By SRVMTrainings   0  
Similarity between Router and Filter is that both transformation would be 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 rerouted to DAFAULT group. 2.Using filter transformation, one would be able to pass data to next transformation based on single filter pipeline condition. There is no option of routing data that doesnÂ’t match the condition like ROUTER Transformation.
flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert