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?
- 1 Answers
- 7339 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 function of look up transformation?
What is the difference between stop and abort in informatica
How to improve the performance of a session using sorter transformation?
What are the new features of informatica 9.x at the developer level?
What are the different types of olap? Give an example?
What are data-driven sessions?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
Explain lookup transformation in informatica
What is the difference between a repository server and a powerhouse?
What is union transformation in informatica?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
list out all the transformations which use cache?
Enterprise data warehouse your projects phase by phase explain?
Explain what transformation and how many are there in informatica?
What are active and passive transformations?
