1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i<2in the different groups
what is the o/p in the target

Question Posted / venki.malneni

Answers were Sorted based on User's Feedback



if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i&l..

Answer / moorthy g

Source have 10 Records

Router

I>2 3,5...10 (Tgt1)

I=5 ONLY 5 (Tgt2)

I<2 1-2 (Tgt3)

Is This Answer Correct ?    14 Yes 5 No

if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i&l..

Answer / shyam reddy

Total 10 records will come. When we use Router t/r each
record will pass through every group. If it is not satisfied
any user defined conditions it will go to the Default group.

Is This Answer Correct ?    7 Yes 0 No

if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i&l..

Answer / ravi sagar

Router

I>2 3,5...10 (Tgt1)

I=5 ONLY 5 (Tgt2)

I<2 only 1 (Tgt3)

Is This Answer Correct ?    10 Yes 3 No

if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i&l..

Answer / james

Answer 4 is absolutely correct.
Bcoz third condition is i>2 ,
so u won't be getting the second recond.

If my justification is wrong please correct it
with proper answer don't simply click on NO

Is This Answer Correct ?    6 Yes 2 No

if i have 10 records in my source,if we use router t/r and given the condition as i>2,i=5 and i&l..

Answer / chandrasekar

The above scenario I took an one table like emp table, I
took the coloumn as deptno ,I have created 3 targets and
created one router T/r , condition like that one is
deptno>20 , deptno=20 and deptno<30.

In that if the deptno>20 condition satisfies then the
particular record who has deptno above 20 which can be
loaded into one target. The same as other 2 conditions. If
the condition satisfied then it can loaded to particular target.

if it wrong means please mail me chandranmca2007@gmail.com

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Informatica Interview Questions

In real time scenario where can we use mapping parameters and variables?

4 Answers   CSC, CSE,

There are two sessions are connected to the workflow. When the first session run load the data(employees data sum_salaries <= 1000000) into the target1. When the second session run load the data(employees data sum_salaries > 1000000) into the target2. How to achieve this?

1 Answers   Wipro,

hi all, can anyone please tell me the difference between erwin tool and informatica ?how these both works ? how this both are going to connect with business objects. THANKS IN ADVANCE

2 Answers  

i have source like X1 10 X2 20 X1 30 X2 40 i want target as X1 X2 10 20 30 40 in informatica

2 Answers   HP,

What do you understand by a term domain?

0 Answers  




Define Update Override?

1 Answers  

write sql query following table quarter sales q1 1000 q1 2000 q1 3000 q1 4000 q2 5000 q2 6000 q2 7000 q2 8000 q3 1000 q3 2000 q3 3000 q3 4000 q4 5000 q4 6000 q4 7000 q4 8000 i want the output format like q1 q2 q3 q4 1000 5000 1000 5000 2000 6000 2000 6000 3000 7000 3000 7000 4000 8000 4000 8000

5 Answers   CTS,

HOW DO YOU PARFORM INCREMENTAL LAOD ?

7 Answers   SAIC,

Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V

2 Answers   NTT Data,

Implementation methodology

0 Answers  

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

0 Answers  

Can we run session without using workflows?

5 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories