Can anyone please distinguish what is Inner join and Outer join
- 2 Answers
- 5688 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
need for registering a repository server
What can we do to improve the performance of informatica aggregator transformation?
While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?
What is factless fact schema?
What are the limitations of joiner transformation?
Define maping and sessions?
My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?
Does Facttable Normalized or Denormalized?
In mapping f.f as one src and f.f as trg,f.f as src and oracle as trg which is fast? mean which is complete first process
In dimension and fact table? which one holds big data?
If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?
what is the use of Java Transformation in Informatica 8.x?
Teradata 
