Interested to Buy Any Domain ? << Click Here >> for more details...
Can anyone please distinguish what is Inner join and Outer join
- 2 Answers
- 6152 Views
- Wipro, I also Faced
- E-Mail Answers
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 does a rank transform differ from aggregator transform functions max and min?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What are the reusable transformations?
Explain dynamic target flat file name generation in informatica
What is rank transformation in informatica
Explain the difference between a data warehouse and a data mart?
What is enterprise data warehousing?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
Enlist the various types of transformations.
What are the different lookup cache(s)?
explan ur project architecture?
Can u generate reports in Informatica?
What is rank transformation?
What are the types of caches in lookup?
What are different types of transformations available in informatica?
