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
- 5681 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
When do you use sql override in a lookup transformation?
What do you mean by worklet?
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
Under what condition selecting sorted input in aggregator may fail the session?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
How you can differentiate between connected lookup and unconnected lookup?
Separate from an archive server and a powerhouse?
How to start a workflow using pmcmd command?
What is data transformation manager process?
tell me the rules and responsblites in our project(my project is development)
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What are the different lookup cache(s)?
Target increases every day even though no new record was inserted
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is a transaction control transformation?
