Interested to Buy Any Domain ? << Click Here >> for more details...
Can anyone please distinguish what is Inner join and Outer join
- 2 Answers
- 6409 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
INNER JOIN MEANS, IF THE JOIN CONDITION SATISFIES THEN ONLY
BOTH TABLE RECORDS ARE JOINED OTHERWISE REJECTED.
IF THE JOIN TYPE IS OUTER JOIN MEANS THERE IS JOINED THE
RECORDS WITH MATCHING AND NON MATCHING RECORDS.
if it wrong means please mail me chandranmca2007@gmail.com
| Is This Answer Correct ? | 3 Yes | 0 No |
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 |
what is diffrence b/w joner and union transfermation
How to extract sap data using informatica?
There are 100 lines in a file. How to print line number 31-50 and 81-90 in unix with a single command.
What is meant by target load plan?
What is difference between maplet and reusable transformation?
WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER? chandumba2005@gmai.com
Please let me know how to do estimation before staring development in project. Here estimation in the sense how many associates are required, etc to complete the project.
i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.
What is rank transformation in informatica
What is the difference between warehouse key and surrogate key?
what is surrogatekey ? In ur project in which situation u has used ? explain with example ?
normalizer transformation
Teradata 
