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
How do you promote a non-reusable transformation to reusable transformation?
wat are deployement groups in informatica, how it will be used for developers
What are roles and groups and benefits of using them?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What do think which one is the better joiner or look up?
What are the tasks that can be performed using sq?
How to handle decimal places while importing a flatfile into informatica?
What does refresh system mean, and what are its distinctive choice?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
How can repository reports be accessed without sql or other transformations?
Briefly define reusable transformation?
How to delete duplicate row using informatica?
What is the difference between informatica 7.0 and 8.0?
What are the types of caches in lookup?