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?
- 1 Answers
- 6567 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
How to improve the performance of a session using sorter transformation?
What are the new features of informatica 9.x at the developer level?
Partition, what happens if the specified key range is shorter and longer
What are Dimensional table?
How can you define user defied event?
what is Active lock explain
How to open an older version of an object in the workspace?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
Explain scd type 3 through mapping.
How to implement security measures using repository manager?
Can u generate reports in Informatica?
How can we improve session performance in aggregator transformation?
What is the surrogate key?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
