There are 3 groups in router transformation in which there are no conditions m

There are 3 groups in router transformation in which there
are no conditions mentioned, so what happens if I connect
these groups to the 3 targets? How many records gets into
each target.(suppose if we are getting 10 records from the
source)

Question Posted / dantu.manohar

4 Answers
8678 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

There are 3 groups in router transformation in which there are no conditions mentioned, so what ha..

Answer / chakri

10 records into 1 target
10 records into 2 target
10 records into 3 target

Is This Answer Correct ?

32 Yes

0 No

There are 3 groups in router transformation in which there are no conditions mentioned, so what ha..

Answer / eswar

All the 3 targets get 10 recrods each

Is This Answer Correct ?

8 Yes

0 No

There are 3 groups in router transformation in which there are no conditions mentioned, so what ha..

Answer / venky

3 group conditions are defaultly true
so,each target get 10 recards
totally 30 records

Is This Answer Correct ?

4 Yes

0 No

There are 3 groups in router transformation in which there are no conditions mentioned, so what ha..

Answer / raju

Without condtion by default all rows are load to given target/targets.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer

More Informatica Interview Questions

I have been working in Informix-4gl for the past 2 years in an MNC company.But I'm interested to work in Business Intelligence tools. Is it possible to change the technology now? I'm really confused, please help me

1 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,

How can we update a record in the target table without using update strategy?

0 Answers

wt is Dynamic lookup Transformation? when we use?how we use?

2 Answers TCS,

What are the different types of schemas?

11 Answers ITC Infotech,

Is there any way to read the ms excel datas directly into informatica?

0 Answers

IN A MAPPING WHEN WE USE AGGRIGATER TRANSFORMATION WE WILL USE GROUP BY PORT. IF GROUPBY IS NOT SELECTED BY DEFAULT IT WILL TAKE ONLY THE LAST COLUMN WHY????

3 Answers IBM,

Tell me about informatica architecture.

2 Answers TCS,

I have source table 100 records after run session successfully but loads the target table 50 records only what happened that 50 records and how can i load remaining 50 records

5 Answers Patni,

How the informatica server increases the session performance through partitioning the source?

1 Answers

source table A having 100000 records. and target B table having 100000 records. now iam updating B records using update query. i don't know which record is update in target. write a sql query get all updated records from target table B.

4 Answers TCS,

how to get max value record into one target and remaining records into another target?

2 Answers Accenture,

For more Informatica Interview Questions Click Here