suppose we have 1 to 10 records.In router transformation we had given two condi

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?

Question Posted / minisweet85

2 Answers
6857 Views
emc2, I also Faced
E-Mail Answers

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

I have one source table and three target tables. When the session runs for the first time involving the mapping,i want that the loading should take place in 1st Target table only. The 2nd time the same session runs the loading should take place in 2nd Target only only and similarly when the session runs for the 3rd time loading should take place in Third only. And again when the session runs for the 4th time loading should take place in 1st Target table.

4 Answers Cap Gemini, IBM,

What is an MDDB? What is the difference between MDDBs and RDBMSs?

3 Answers

What is a candidate key?

7 Answers CTS,

How do you change parameter when you move it from development to production.

1 Answers

HOW TO DELETE A RECORD FROM FLAT FILE

6 Answers TCS,

in what type of scenario bulk loading and normal loading we use?

2 Answers Cognizant, Wipro,

Do you have to change the reject file b4 using reject loader utility.

1 Answers

Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?

2 Answers IBM,

what is mystery dimension?

1 Answers

Hi, What is exactly node ? what is exactly domain ? How loadbalancer will work ? what is Integration service (IS) ? Can anyone give me exact scenario when I click on start workflow in the workflow manager ? (Note : I am not expecting answer like, node means logical representation of a machine and domain will contain multiple nodes .I gone through Informatica help but I couldn’t understand. I am expecting exactly what is happening in background detailed explanation or Pictorial representation will be highly appreciation ) Advance thanks

3 Answers IBM,

How to compare Source and Target table, without using dynamic lookup?

4 Answers

Define error Threshold?

1 Answers

For more Informatica Interview Questions Click Here