suppose we have 1 to 10 records.In router transformation we
had given two condition
A>= 5
A<=5
then what will be the output?

Answers were Sorted based on User's Feedback



suppose we have 1 to 10 records.In router transformation we had given two condition A>= 5 A<..

Answer / srinivas

A>=5 ---> target1 output is 5th to 10th record
A<=5 ---> target2 output is 1st to 5th record

Is This Answer Correct ?    16 Yes 4 No

suppose we have 1 to 10 records.In router transformation we had given two condition A>= 5 A<..

Answer / mike

If you create two groups in the router transformation and
you want to load the records in to two target tables then

src-->srcq--->router-->/t1
\t2..The records which meet the
condition in the first group will pass in to the T1 and the
records which meet the condition in the second group will
pass in to the T2...i mean to say all the records that
matches the condition will come as an output


correct me if i was wrong

Is This Answer Correct ?    7 Yes 6 No

Post New Answer

More Informatica Interview Questions

Explain how to import oracle sequence into informatica?

0 Answers  


explain about informatica server architecture?

1 Answers   IBM,


i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?

9 Answers   Cap Gemini,


What is the Rankindex in Ranktransformation?

7 Answers  


What are the conditions needed to improve the performance of informatica aggregator transformation?

0 Answers  






which transformation uses cache?

3 Answers   Keane India Ltd,


write sql query to filter the null value data following table? name age john 30 smith null null 34 sharp 24 i want the output following are name age john 30 sharp 24

2 Answers   HP,


How can one identify whether mapping is correct or not without connecting session?

0 Answers  


i have oracle table A and target B. i don't know how many records. i want get get last record in table A as first record in target table B. write a sql query?

7 Answers   IBM, TCS,


What are the tasks that can be performed using sq?

0 Answers  


what happens when a batch fails?

3 Answers  


What are conformed dimensions?

1 Answers  


Categories