Differnce between filter and router?

Answer Posted / jang

If we what to test for multiple conditons, then we need to
have multiple Filters TRN's, so each filter TRN scans the
data. Where as in Router TRN data is only once scan or read
to evaluate the conditions, so the performance may be good
with router.

Is This Answer Correct ?    7 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can informatica load heterogeneous targets from heterogeneous sources?

693


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

595


What is event and what are the tasks related to it?

612


What is joiner transformation?

583


What is a router transformation?

621






How many transformations can be used in mapplets.

1454


Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

1584


What is joiner change?

669


Enlist the tasks for which source qualifier transformation is used.

585


What is the need for an etl tool?

631


What is informatica metadata and where is it stored?

581


Repository user profiles

1373


What are the new features of informatica 9.x developer?

530


What is decode in informatica?

650


source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2293