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
- 6560 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
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?
What the difference is between a database, a data warehouse and a data mart?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
When do you use sql override in a lookup transformation?
What is a surrogate key?
Explain the types of lookup transformation?
How can we use mapping variables in informatica? Where do we use them?
Why union transformation is an active transformation?
What is the need for an etl tool?
Explain incremental aggregation in informatica
Differentiate between source qualifier and filter transformation?
What are connected or unconnected transformations?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
wf dont have integration severances how you can run?
What do you mean by filter transformation?
