Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

What is CHECK-IN CHECK-OUT. Please explane me?

3 Answers   TCS,

What are batches?

0 Answers  

when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/

5 Answers   L&T,

Define sessions in informatica etl?

0 Answers  

what is mean by complex business rule ?

0 Answers   Cap Gemini,

How to elaborate powercenter integration service?

0 Answers  

suppose if we have dublicate records in a table temp n now i want to pass unique values to t1 n dublicat values to t2 in single mapping?how

4 Answers   CTS,

What is enterprise data warehousing?

0 Answers  

What is parallel processing in informatica?

0 Answers  

Limitation of REPLACESTR. Is there any character limitation to it.

1 Answers   CTS,

How to identify bottlenecks in sources,targets,mappings,workflow,system and how to increase the performance?

4 Answers  

HOW TO YOU LOAD TIME DIMENSION

1 Answers  

For more Informatica Interview Questions Click Here
Categories