Interested to Buy Any Domain ? << Click Here >> for more details...
Can anyone please distinguish what is Inner join and Outer join
- 2 Answers
- 6151 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 |
Informatica and datawarehousing courses in Pune?
How would you join a node to the already existing domain?
What are slowly changing dimensions?
5 Answers Informatica, Verinon Technology Solutions,
What are pre and post-session shell commands?
What is incremental aggregation and how it is done?
8 Answers JPMorgan Chase, TCS,
Mention a few design and development best practices for informatica?
Session Recovery. 1000 rows in the source of which 500 passed through and then I killed the session. Can you perform a recovery and how
What differs when we choose the sorted input for aggregator transformation?
Can you please mail me a copy of Informatica Certification Exam dumps to sriveniv@hotmail.com
Informatica software installation 8.1/7.1.3/7.1 with oracle 10g database (optional Teradata v2R6)
why normalizer transformation can not used in mapplet? plzzzz answer
How an expression transformation differs from aggregator transformation?
Teradata 
