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
- 6466 Views
- IBM, Polaris, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the different ways to implement parallel processing in informatica?
What is meant by active and passive transformation?
What is intricate mapping?
How to do unit testing in informatica?
What are the different clients of powercenter?
How to extract sap data using informatica?
What all are steps in up gradation of Informatica server?
Explain scd type 3 through mapping.
Write the program through which the records can be updated?
How you prepared reports for OLAP?
What is status code in informatica?
What is the advantage of informatica?
How to create a non-reusable instance of reusable transformations?
How can one identify whether mapping is correct or not without connecting session?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
