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

My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?

3 Answers   Cap Gemini,

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

0 Answers   TCS, Wipro,

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

3 Answers  

how can we use sorter transformation in joins?

5 Answers   IBM,

What is CDC? How to implement CDC?

4 Answers   People Tech, TCS,

What is a code page in Informatica

3 Answers   American Express, Cognizant, Deloitte,

in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?

11 Answers   L&T,

what is shortcut in informatica? difference between shortcut,reusable object?

2 Answers   Virtusa,

what are the reusable tasks in informatica ?

11 Answers   CTS, HP, IBM, TCS,

When the informatica server marks that a batch is failed?

1 Answers  

What if the source is a flat-file?

0 Answers  

hi guys i have an question how do you find out weather the column is numeric or combination of char and numbers or it contains char,numeric and special characters.

2 Answers   IBM,

For more Informatica Interview Questions Click Here
Categories