Interested to Buy Any Domain ? << Click Here >> for more details...
Can anyone please distinguish what is Inner join and Outer join
- 2 Answers
- 6410 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / sehaj
INNERJOIN-GIVES THAT RECORDS THAT ARE PRESENT IN BOTH THE TABLE
OUTERJOIN-GIVES THAT RECORDS WHICH ARE PRESENT AND ALSO
WHICH ARE NOT PRESENT IN ONE OF THE TABLE.
INEERJOIN-REQUIRES LESS PROCCESING TIME.
OUTERJOIN-REQUIRES THE MAX PROCESSING TIME AMONG ALL THE
KIND O JOINS.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can we create two repositories on same database instance in oracle?
What is data transformation manager process?
What is a code page?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
How to load a Dimension ? and how to load a fact table?
Explain in detail about scd type 1 through mapping.
Can you use flat files in Mapplets.
Explain dynamic target flat file name generation in informatica
Why do we need informatica?
What are the advantages of informatica?
What is a connected transformation?
Write the unconnected lookup syntax and how to return more than one column.
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
