What is the Router transformation?

Answer Posted / manjunath

Router transformation is a active and connected transformation,
It is used to test multiple conditions in which it has two groups 1.Input group 2. output group . In router transformation
rejected rows will be sent to default group where we dont have in filter t/f. Router t/f is connected to multiple targets.

Let me know if iam wrong

Is This Answer Correct ?    5 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define enterprise data warehousing?

630


How can we store previous session logs?

561


what is $$$$?

1727


What is data caches/ index caches?

608


How many dimensions are there in informatica?

623






Briefly define reusable transformation?

619


How to partition the Session?

638


Where are the source flat files kept before running the session?

620


The question was on time stamp. what is the difference between HH and HH24 when to use when.

1546


What are session parameters ? How do you set them?

1371


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

689


Can u generate reports in Informatica?

651


Parameter and variable differences

1613


how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.

1247


What are the limitations of joiner transformation?

647