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
- 6556 Views
- TCS, I also Faced
- E-Mail Answers
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 |
how to load rows into fact table in data warehouse
What is a code page?
How can we store previous session logs?
i have 2 session s1 execute s2 load first session fail what is the reason?
what is the difference between lookupoveride and joiner?
How to get EVEN & ODD numbers separately?
what are 3 tech challenges/ common issues you face?
Input is like 1 1 1 2 2 3 and out put should be 1 2 3 How can u acheive using rank transformation ??
WHAT IS THE DIFFERENCE B/W 7.X AND 8.X ? TELL ME FEW DIFFERENCES.
what is the -ve test case in your project.
If we are using an aggregator but forget to mention the group by port .what will be the output??
can we use bulk loading when we use look in mapping
Teradata 
