,if we have single SQ in flow and we have router in which it
has two group and we want to join these two groups with
joiner ?is it possible?

Answers were Sorted based on User's Feedback



,if we have single SQ in flow and we have router in which it has two group and we want to join thes..

Answer / sree

It is not possible to connect output groups of router with
joiner transformation.

Is This Answer Correct ?    7 Yes 1 No

,if we have single SQ in flow and we have router in which it has two group and we want to join thes..

Answer / adithya amanchi

Router transformation is all about dividing data into group
of records based on one or more conditions. For example,
assuming a building as table with 10 floors considering each
floor as a record. The first three floors are for parking,
next three are for cinema halls and rest are for shopping.
It is nothing but making a vertical table into pieces.

Joiner transformation is nothing but depending upon common
columns(attributes or fields) or primary and foreign key
relationship combining two or more tables horizontally.
Making the table wider. similar to above example, joining
two buildings of different floors making one side of each
building as common.


hope this will help you guys

Is This Answer Correct ?    5 Yes 0 No

,if we have single SQ in flow and we have router in which it has two group and we want to join thes..

Answer / mehul

Hi Sree

Could u please elaborate your solution

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

0 Answers  


What is diff joiner and lookup

4 Answers   BirlaSoft,


How can i send first half of the records to one target and Remaining to other target?

10 Answers   TCS,


Whats there in global repository

0 Answers  


Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?

2 Answers   Infotech,






What is the difference between SOURCE and TARGET BASED COMMITS?

3 Answers   IBM,


Difference between STOP & ABORT in Informatica.

3 Answers   Accenture, Wells Fargo,


Explain what is informatica metadata and where is it stored?

0 Answers  


What is the difference between Normal load and Bulk load?

5 Answers  


How to fix the etl bugs..Tell me the process?

1 Answers   IBM,


Can yoU use the maping parameters or variables created in one maping into another maping?

2 Answers  


Can we schedule a workflow(not a session) to run after completition of another workflow? Can we make a workflow depend on completition of another one?

2 Answers   GE,


Categories