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 anyone tell me the new features in Informatica 9 Version?

1823


Mention a few design and development best practices for informatica?

777


EXL informatica Questions

1174


What is primary and backup node?

958


Explain what are the different versions of informatica?

901


lookup transformation with screenshots

3796


How we can create indexes after completing the load process?

968


What can we do to improve the performance of informatica aggregator transformation?

890


SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

1900


How to join three sources using joiner? Explain though mapping flow.

927


Enlist the tasks for which source qualifier transformation is used.

811


which one is better performance wise joiner or look up

885


How to call shell scripts from informatica?

795


To import the flat file definition into the designer where should the flat file be placed?

875


How do you promote a non-reusable transformation to reusable transformation?

940