i have two tables,table 1 having 2 columns and 3
rows,table2 having 3 columns and 2 rows.what is the output
if i do left outerjoin,full outer join,right outer join?
- 2 Answers
- 5666 Views
- IBM, Polaris, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / pradosh
in table data like following
left table1 right table2
c1,c2 c3,c4,c5
1,2 1,1,10
4,5 6,5,12
7,8 matching columns c1 and c3
Right outer join c1,c2,c3,c4,c5
1,2,1,1,10.
-,-,6,5,12.
Left outer join 1,2,1,1,10.
4,5,-,-,-.
7,8,-,-,-.
full outer join 1,2,1,1,10.
4,5,-,-,-.
7,8,-,-,-.
-,-,6,5,12.
'-' indicates null in above table
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / vijaya
in table data like following
left table1 right table2
c1,c2 c3,c4,c5
1,2 1,1,10
4,5 6,5,12
7,8 matching columns c1 and c3
left join c1,c2,c3,c4,c5
1,2,1,1,10.
-,-,6,5,12.
right join 1,2,1,1,10.
4,5,-,-,-.
7,8,-,-,-.
full outer 1,2,1,1,10.
4,5,-,-,-.
7,8,-,-,-.
-,-,6,5,12.
'-' indicates null in above table
| Is This Answer Correct ? | 6 Yes | 5 No |
what is SDLC way of code development?
In a sequential batch can u run the session if previous session fails?
how can we load first and last record from a flat file source to target?
7 Answers Infosys, ITC Infotech,
What is status code?
what is surrogatekey ? In ur project in which situation u has used ? explain with example ?
how to move the mappings from your local machine to claint place?
What is critical mapping?
How can we get multiple output values using an unconnected lookup transformation?
What are the transformations that are not supported in mapplet?
wt is inline view? when and why we Use ?mail to rayallarv@gmail.com
difference between repository database and repository service?
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
Teradata 
