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
8834 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

What is the difference between OLTP and ODS?

4 Answers

i did MBA in 2008. i got job as a Software Engineer(Informatica) in 2008 February in our college campus interviews through consultancy. my problem is when iam going interview HR people ask " YOu are MBA graduate how u get software(informatica) job". iam saying i got job in campus interviews. i have knowledge in informatica in dataware housing. is this answer correct or not. plese give me guidence

1 Answers IBM,

what is a transforamation?

5 Answers

Hello, I have the below table: CityID CityName CostOfLiving 1 Mumbai 5000 1 Bangalore 4500 1 Chennai 4800 2 Vapi 6000 3 New Delhi 8000 I am passing the rows of the above table through the aggregator transformation in Informatica What happens in the following conditions: 1) I specify no group-by ports? 2) I specify a group-by on CityID without making any separate post for aggregation? Which city and costofliving will this eventually take for CityID=1? 3) Rest being same as point 2,I take the sum of cost of living.Which city will be returned for ID=1? Thanks for your help!

1 Answers

How do you recover rows from a failed session

1 Answers

If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?

2 Answers TCS,

What are the components of workflow manager?

0 Answers

How can you define a transformation? What are different types of transformations in Informatica?

10 Answers

How to improve the session performance in informatica?

3 Answers Accenture,

Hello , I am unable to work with SQL transformation at least. Where do i need to give connection for sql transformaton ? At session level there is no property . I have created a SQL Transformation and chosen query mode. But do i need to pass connection information to it ? I don't know where do i need to write a query ? I have written a query in file and that file path i gave in the properties of SQL Transformation. But it is not working. Could any one of you please let know how can i work with SQL Transformation? Advance Thanks.

0 Answers IBM,

how to calculate the optimum cache size in aggregator transformation?

1 Answers

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,

For more Informatica Interview Questions Click Here