Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Can anyone please distinguish what is Inner join and Outer join

Answer Posted / chandrasekar

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the use of transformation?

1002


Is it possible to revert a global repository to local one and why?

1086


Explain about Informatica server process that how it works relates to mapping variables?

1088


What are mapplets?

1281


What is informatica powercenter repository?

1207


without table how to come first record only in oracle?

2260


waht type of interface is used for testing the data in informatica

2259


Write the advantages of partitioning a session?

1285


What are roles and groups and benefits of using them?

1057


How to generate or load values in to the target table based on a column value using informatica etl tool.

1081


can u any challenge your project?

2036


How do you load first and last records into target table?

1159


Differentiate between router and filter transformation?

1017


What are active transformations.

1659


Describe the impact of several join conditions and join order in a joiner transformation?

1063