Sign Up Login


  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 have two sources both is oracle database . one is coming from USA database and another one is coming from U.k database .i am using source qualifier transformation to join this.as that time in session level source properties which path i need to give to retrieve that data. thanks bala 09619894486

2 Answers   Accenture,

How you can differentiate between connected lookup and unconnected lookup?

0 Answers  

Why do you use Mapping Parameter and mapping variable?

0 Answers  

Hi, As shown below i have repositories under that some folder are there . Between these repositories and folder some thing is there.I want to know what is that? repositories repo1 repo2 repo3 IS_## IS_## IS_## Folder1 Folder2 Folder3 - - - Here i want to what IS_## represents ? Advance Thanks

1 Answers   IBM,

list out all the transformations which use cache?

0 Answers   Informatica,

without using rank transformation how can we rank items by using some other transformations

2 Answers  

why we use datawarehouse

0 Answers   HCL,

i have 5 session (s1,s,2,s3,s4,s5)i want to execute first 4 session after 5th session how will you do?

8 Answers   iNautix,

How to improve the performance of Aggregate transformation?

3 Answers   Dmss,

if we r using aggregator we enabled sorted input but the records r not sorted what happen?

7 Answers   HSBC,

In joiner, how to load Master table in Target?

2 Answers  

Can we use the mapping parameters or variables created in one mapping into another mapping?

1 Answers   Informatica,

For more Informatica Interview Questions Click Here
Categories