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
- 6537 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
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is meant by incremental aggregation?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
Different sorts of metadata that stores in the storage facility?
What is a surrogate key?
permutations of mapplet
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?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
What are the designer tools for creating transformations?
What is flashback table ? Advance thanks
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What are the databases that informatica can connect to windows?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
