Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6571 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
How to use pmcmd utility command?
What is the maplet?
What is the benefit of session partitioning?
Explain sql transformation in script mode examples in informatica
What is sq transformation?
In warehouses how many schemas are there?
What are the issues you have faced in your project? How did you overcome those issues?
Explain in detail about scd type 1 through mapping.
What does command task mean?
tell me the rules and responsblites in our project(my project is development)
Different qualification between a related rotate toward the sky and isolates look upward?
Tell me about Propagate functions in informatica
How can you differentiate between powercenter and power map?
wf dont have integration severances how you can run?
complex mapping ur project u r invlve can u explain and give real time example give me ?
