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
- 5696 Views
- IBM, Polaris, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Scheduling properties,whats the default (sequential)
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
How to update source definition?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
How can one identify whether mapping is correct or not without connecting session?
What is the use of code page?
Explain the different lookup methods used in informatica?
Explain lookup transformation is active in informatica
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
How big was your fact table
Can you generate sequence numbers without using the sequence generator transformation?
Could you explain what is enterprise data warehouse?
What are the various types of transformation?
What is a standalone command task?
what is size of u r database?
