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
- 6663 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 is rank transform?
Explain your project of banking domian.
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What are the advantages of informatica?
Why is sorter an active transformation?
What are some examples of informatica etl programs?
What does refresh system mean, and what are its distinctive choice?
What is joiner transformation in informatica?
What are the differences between oltp and olap?
What is the fact table?
What is the difference between source qualifier transformations source filter to filter transformation?
How can we update a record in the target table without using update strategy?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
What are the measure objects?
How to join three sources using joiner?
