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

Define filter transformation?

0 Answers  


waht type of interface is used for testing the data in informatica

0 Answers   CTS, TCS,


how did u understand business requirement?

2 Answers   TCS,


wf dont have integration severances how you can run?

0 Answers   TCS,


HOW TO YOU LOAD TIME DIMENSION

1 Answers  






If i have one source having 10 ports.In a mapping i use that source one target having that ten ports.Data from 5 ports are going to target through a mapplet and another 5 ports are going to target through another mapplet.Both 2 mapplets are intially passive in nature.But presently my requirment to convert on mapplet to ACtive.How can i do it.

3 Answers   TCS,


What are the challenges you have faced in your project?

1 Answers   Cognizant, Infosys,


List the transformation in informatica.

1 Answers   TCS,


what are the limitations of pushdown optimization technique ? Advance thanks

3 Answers   Puma,


my source having the records like ram 3 sam 5 tom 8 and i want to load into target like ram record 3 times,sam record 5 times, tom record 8 times

3 Answers   Satyam,


When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?

1 Answers  


How do you do error handling in Informatica?

1 Answers  


Categories