Can anyone please distinguish what is Inner join and Outer join
- 2 Answers
- 5251 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 |
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
when we dont use aggregator in mapping ?
What are the advantages of informatica?
When i run workflow first session runs 4 times 5th time 2nd session must run? How can u do?
How do you implement scheduling in Informatica?
What is a test load?
What are the different clients of powercenter?
What is 'PowerCenter Pushdown Optimization Option' in INFORMATICA ?
i have 2 mapings for this 2 mapings i want use only one lookupt/r how?
How are parameters defined in informatica?
what is lookupoverriding?
connected and unconnected lookups?
Teradata 
