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
- 6556 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 can we use batches?
What is decode in informatica?
What do mean by local and global repository?
Clarify the utilization of aggregator cache record?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
On which transformations you created partitions in your project?
what is INFORMATICA TESTING process
What is a grid in Informatica?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
what is the difference between informatica6.1 and infomatica7.1
What is enterprise data warehousing?
What are the reusable transformations?
How to generate sequence numbers?
The question was on time stamp. what is the difference between HH and HH24 when to use when.
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
