Can anyone please distinguish what is Inner join and Outer join
- 2 Answers
- 5277 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / sehaj
INNERJOIN-GIVES THAT RECORDS THAT ARE PRESENT IN BOTH THE TABLE
OUTERJOIN-GIVES THAT RECORDS WHICH ARE PRESENT AND ALSO
WHICH ARE NOT PRESENT IN ONE OF THE TABLE.
INEERJOIN-REQUIRES LESS PROCCESING TIME.
OUTERJOIN-REQUIRES THE MAX PROCESSING TIME AMONG ALL THE
KIND O JOINS.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to convert multiple rows to single row (multiple columns) in informatica
what is index?how it can work in informatica
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Have you worked with/created Parameter file
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What are junk dimensions?
Why update strategy and union transformations are active?
What is informatica etl tool?
Why filter transformation is an active one?
How to delete duplicate row using informatica?
What is informatica metadata and where is it stored?
What is a joiner transformation?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
What will be the approach?
Under which circumstances, informatica server creates reject files?
