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


If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p if we perform normal join,Master outer join,Detail outer join and Full Outer join how?



If we have a two tables A & B A contain 10 records,B contain 20 records,what w'll b the o/p..

Answer / gurpreet singh

Normal Join - All matching rows of A and B
Master Outer join - All rows of detail including matching
rows from master
Detail Outer join - All rows of Master including matching
rows from detail.
Full outer join - All rows from Master and detail table
including matching rows.

Is This Answer Correct ?    14 Yes 0 No

Post New Answer

More Informatica Interview Questions

Please let me know how to make Data masking in informatica..

0 Answers  


what is the diff b/w union and joiner and lookup?

4 Answers  


What is update override?

1 Answers   Accenture,


What is a grid in Informatica?

0 Answers  


what are the transformations that restricts the partitioning of sessions?

1 Answers  


I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?

3 Answers  


what is the flat file partition and where have to specify it

1 Answers   TCS,


What is union transformation?

0 Answers  


get me the resultant input:- 1 x,y,z output:- 1 x 2 a,b 1 y 3 c 1 z 2 a 2 b 3 c

3 Answers   Infosys,


What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?

8 Answers   TCS,


Sequence generator, when you move from develoment to production how will you reset

0 Answers  


in realtime which situations u can use unconnected lookup transformation

2 Answers   Patni,


Categories