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

I need an oracle query for convert Char to Integer?. Can any one help me how to do this?

3 Answers  

Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

0 Answers   Informatica,

If informatica has its scheduler why using third party scheduler?

0 Answers  

What is the difference between Bulk Load and Normal Load

3 Answers   TCS,

Work flow failed when it is set to Bulk mode but it was successful when set to normal mode y??(All the connections are fine and exactly correct)?

11 Answers   Wipro,




Difference between task flow and linear task flow

0 Answers  

what is the location of parameter file in informatica?

1 Answers   TCS,

when informatica 8 series released ?

1 Answers   IBM,

Is LOAD MANAGER AND LOAD BALANCER same in informatica?

1 Answers   KPIT,

what is mean by grouping of condition column in lookup transformation?

1 Answers  

What will be the approach?

0 Answers  

Is it possible to update the target table with PK?

1 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories