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
- 6431 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
What is difference between a gateway node and worker node?
What is a grid in Informatica?
What is confirmed fact in dataware housing?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
What do you mean by enterprise data warehousing?
Explain how to import oracle sequence into informatica?
What is the command used to run a batch?
How to create a non-reusable instance of reusable transformations?
How to extract sap data using informatica? What is abap? What are idocs?
How do you set a varible in incremental aggregation
Please let me know how to make Data masking in informatica..
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
Implementation methodology
what is degenerated dimension?
Where are the source flat files kept before running the session?
