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
What is the use of transformation?
Is it possible to revert a global repository to local one and why?
Explain about Informatica server process that how it works relates to mapping variables?
What are mapplets?
What is informatica powercenter repository?
without table how to come first record only in oracle?
waht type of interface is used for testing the data in informatica
Write the advantages of partitioning a session?
What are roles and groups and benefits of using them?
How to generate or load values in to the target table based on a column value using informatica etl tool.
can u any challenge your project?
How do you load first and last records into target table?
Differentiate between router and filter transformation?
What are active transformations.
Describe the impact of several join conditions and join order in a joiner transformation?