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
- 6088 Views
- IBM, Polaris, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
What is a node in Informatica?
In CSV flat file date are in the following format. dd/mm/yyyy (05/01/2005)and d/m/yyyy (5/1/2005) and dd/m/yyyy (05/1/2005) and d/mm/yyyy (5/01/2005). It should be load to target in a unique format. How will you implement this?
What are pre and post-session shell commands?
why we use materialized view over view?
What is the difference between view and materialised view?
What is joiner transformation?
If u select groupby port in aggregator what is output and dont select groupby option what is output
After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can you map these three ports directly to target?
How do you migrate data from one environment to another?
How do you handle decimal places while importing a flatfile into informatica?
Write the different tools in the workflow manager?
How to fasten loading of 100 million distinct records in informatica? (Initially they are loaded into target without using any transformation, taking 2 hours)
Teradata 
