What is the Router transformation?

Answer Posted / swetha

A Router transformation is similar to a Filter
transformation because both transformations allow you to
use a condition to test data. However, a Filter
transformation tests data for one condition and drops the
rows of data that do not meet the condition. A Router
transformation tests data for one or more conditions and
gives you the option to route rows of data that do not meet
any of the conditions to a default output group. If you need
to test the same input data based on multiple conditions,
use a Router Transformation in a mapping instead of creating
multiple Filter transformations to perform the same task.

Is This Answer Correct ?    19 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to elaborate powercenter integration service?

646


Please let me know how to make Data masking in informatica..

1260


can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

4307


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1491


Describe expression transformation?

631






State the differences between sql override and lookup override?

613


What is the benefit of partitioning a session?

621


what is mean by complex business rule ?

1715


Explain the use of aggregator cache file?

669


Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1314


What do you mean by enterprise data warehousing?

634


what is the -ve test case in your project.

1846


What are the uses of etl tools?

641


Why union transformation is an active transformation?

651


How to generate sequence numbers using expression transformation?

633