Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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)

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

If the records doesnt satisfy the filter condition where will it go?

10 Answers   IBM,


What is Session and Batches?

0 Answers   Informatica,


What is blocking transformation?

0 Answers   Informatica,


performance wise which one is better in joiner and lookup transformation

2 Answers  


What is a transaction control transformation?

0 Answers   Informatica,






Can we create multiple integration service on single repository?

0 Answers  


How do u identify or filter out a 0 byte file available in a folder by using UNIX command?

1 Answers   Wipro,


What is rank index in rank transformation?

0 Answers  


What could be the possible resons of locks by user?

0 Answers  


One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?

0 Answers   TCS,


hi all, i have 1 flat file having 10 rows. like:- id name amt 100 a 100 200 b 200 100 n 300 400 p 3000 100 a 100 600 x 6000 Now i want to load half of this data into one flat file and remaining in other flat file.like :- flat file 1 id name amt 100 a 100 200 b 200 100 n 300 ---------------------- ---------------------- flat file 2 id name amt 400 p 3000 100 a 100 600 x 6000 Plz reply me ASAP.

10 Answers  


What are the ETL tools available in DWH?

6 Answers   Mphasis,






Categories