Can anyone please distinguish what is Inner join and Outer join

Question Posted / rakeshm4119

2 Answers
6295 Views
Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Can anyone please distinguish what is Inner join and Outer join..

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

Can anyone please distinguish what is Inner join and Outer join..

Answer / 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

More Informatica Interview Questions

Hi Experts, I have a source table like this. Name Number Raj 2 Ram 1 Sam 2 John 1 In the target I need the ouptput like the below Raj Raj Ram Sam Sam John We dont know the number value . It will be changing as n.. Please help me regarding this. Thanks, Nataraj V

2 Answers NTT Data,

What is meta data and system catalog?

2 Answers

Separate from an archive server and a powerhouse?

0 Answers

Difference between session variables and workflow variables?

2 Answers Informatica,

TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

0 Answers TCS,

write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500

3 Answers Accenture,

why we r using presql&postsql in source qualifier?

1 Answers HP,

source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks

4 Answers Polaris,

What are the advantages of informatica?

0 Answers

What is a grid in Informatica?

0 Answers

In SCD type 2 if we had select date range. then suppose we had inserted today's date(eq. date is 30 aug 2010) then start date will be today's date(30 aug 2010) what will be the end date,we cant leave it blank?

2 Answers Cognizant, emc2,

what is Active lock explain

0 Answers Satyam,

For more Informatica Interview Questions Click Here