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

how to we create datamart?

2 Answers   HSBC,

What is fact table? Explain the different kinds of facts.

1 Answers  

Hi I have been asked several times the following questions. 1.How does one do incremnental loading 2.Scenario - You are trying to load reasonable amount of rows into the target table, and its taking a helluva lot of time.What could be the reasons? I hate to answer these tw0 , gives me nightmares to even think of it!!! 3.Tell me any complex situation you have faced( as an Informatica Developer) and how did you resolve it. 4.tell me any complex mapping that you have done. All the experienced people out there , please please, reply to these questions.

2 Answers  

What are the transformations that are not supported in mapplet?

1 Answers  

What is lookup transformation?

1 Answers  

what is hash table in informatica?

1 Answers   Zensar,

Normalizer transformation is not involved in Mapplet.. why???

1 Answers   Wipro,

How to load data in informatica ?

1 Answers  

What is checksum termnology in informatica? Where do you use it ?

3 Answers   Chase, Cognizant, Deloitte,

What is the expected value if the column in an aggregator transform is neither a group by nor an aggregate expression?

1 Answers  

how many data models u have done in informatica project?

2 Answers   TCS,

pmscmd startworkflow -sv <host name> -d <domain name> -u <user name> -p <password> -f <folder name> <workflow name> while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1 Answers   HCL,

For more Informatica Interview Questions Click Here
Categories