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
- 5695 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
Separate from an archive server and a powerhouse?
What are the different types of repositories created using informatica?
Does an informatica transformation support only aggregate expressions?
Which transformation should we use to normalise the COBOL and relational sources?
Explain the difference between a data warehouse and a data mart?
Explain why we use partitioning the session in informatica?
How can you generate reports in informatica?
How many numbers of sessions can one group in batches?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Explain the types of transformations?
Whats there in global repository
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Enlist the various types of transformations.
What is the function of aggregator transformation?
What is decode in informatica?
