Can anyone please distinguish what is Inner join and Outer join
- 2 Answers
- 5239 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
What is the different lookup cache(s)?
my source is junk data how will u remove that junk data by using unix please any one replay me
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
What are the uses of etl tools?
What is repository manager?
How do you promote a non-reusable transformation to reusable transformation?
What are the static cache and dynamic cache in informatica?
How to elaborate tracing level?
Differentiate between Load Manager and DTM?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
How can repository reports be accessed without sql or other transformations?
