What is router transformation

Answers were Sorted based on User's Feedback



What is router transformation..

Answer / ravindra.15aug

One source and having multiple targets, it is nothing but
advanced filter. here we are having default group, by this
we can rejected rows.

Is This Answer Correct ?    3 Yes 0 No

What is router transformation..

Answer / krish

it is active transformation, we can use this for applying multiple conditions on data and we can load into multiple targets

Is This Answer Correct ?    1 Yes 0 No

What is router transformation..

Answer / ramkrish.143

When we want perform multiple condition to filter out data
then we go for router. (Say for example source records 50
filter condition mach 10 records remaining 40 records get
filter out but still we want perform few more filter
condition to filter remaining 40 records.)

Is This Answer Correct ?    0 Yes 0 No

What is router transformation..

Answer / c

Router T/R is active and connected T/R .It is used for filtering data for multiple condition and to load in multiple target table.Router T/r stores the rejected data which is not matched the condition in the informatica reserved space as default data.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

if we have certain records,if i need to get 5 th rec for the first time to the target,when i run it for next time,i need to get 6th rec...like that it should process.what wil be the procedure to achieve it??

1 Answers   IBM,


Any one tell me some 5 session failure in real time?And why problem occur how to solve the issues?

1 Answers   Amdocs,


in oracle write query yourname+1 from dual

5 Answers  


What are partitions in informatica and which one is used for better performance?

2 Answers  


I want to get an license to produce excel format output using informatica tool. Anyone help me in this issue. Thanks in advance, Vishnuvardhan

1 Answers  






I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

2 Answers   IBM,


Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

0 Answers  


pmscmd startworkflow -sv <host name> -d <domain name> -u <user name> -p <password> -f <folder name> <workflow name> while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

0 Answers   HCL,


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

0 Answers  


how to create user defined function (udf) in informatica

0 Answers   Informatica,


how to join the two flatfiles using the joiner t/r if there is no matching port?

5 Answers   Cegedim,


How will the document be delivered to me?

0 Answers  


Categories