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
- 5704 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
Explain how many types of dimensions are available in informatica?
How to improve the performance of a session using sorter transformation?
State the limitations where we cannot use joiner in the mapping pipeline?
What are the differences between a connected lookup and unconnected lookup?
What are the data movement modes in informatica?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
How can repository reports be accessed without sql or other transformations?
What is a snowflake schema?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
How to elaborate powercenter integration service?
Sequence generator, when you move from develoment to production how will you reset
How many transformations can be used in mapplets.
I have a flat file, want to reverse the contents of the flat file
What is a pre-defined event and user-defined event?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
