Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

Question Posted / mehul.thakur

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

What are the steps involved in the migration from older version to newer version of Informatica Server?

0 Answers  

Can we create out put ports in source qualifier t/r?

5 Answers   TCS,

I have a condition sal=100 and I created one router and in that two groups g1 and g2 in g1 Sal<=100 and g2 Sal>=100, first which condition will satisfy, and Why?

11 Answers  

Can we update the data in flat file using update strategy?

3 Answers  

can we override a native sql query within informatica? How do we do it?

0 Answers  

Hi,tell me the system testing and Integration Testing in the Informatica ? Thank You

2 Answers   TCS,

What are the types of data that passes between informatica server and stored procedure?

1 Answers   Informatica,

guys which is the best institute in banglore to learn informatica??

2 Answers  

Define informatica repository?

2 Answers   Wipro,

How will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...

1 Answers   Cap Gemini,

tell me the informatica architecture

1 Answers   Banca Sella, Wipro,

Different sorts of metadata that stores in the storage facility?

0 Answers  

For more Informatica Interview Questions Click Here
Categories