Interested to Buy Any Domain ? << Click Here >> for more details...
Can anyone please distinguish what is Inner join and Outer join
- 2 Answers
- 6250 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 are the reusable transforamtions?
What are the challenges of Dataware housing in the future?
task is running successfully but data is not loded why?
How can we create index after completion of load process?
how to load dimension table and fact table. plz tell me the steps.
How to display First letter of Names in Caps?
Why we use lookup transformations?
What is informatica? What exactly are the practical uses in real world
How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT using SQL queries in source qualifier.
what is diff between grep and find
Mapplets can you use an active transformation in a mapplet,
whether Sequence generater T/r uses Caches? then what type of Cache it is
Teradata 
