what is left outer join?
- 3 Answers
- 7710 Views
- L&T, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mahi
It will take all the records form detailed table,
and matching records form master table.
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / jay
For eg.
Select M.*, D.* from
Master M LEFT OUTER JOIN Details D
on M.ID = D.ID
In the above query we get all the records from Master table and matching records from Detail table.
In simple it takes all rows from the table which is left of the join and matching records from table which is in other side of the join.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / rashid equbal
It will take all the records form detailed table,
and matching records from master table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Design a mapping to load a target table with the following values from the above source?
What is the difference between Normal load and Bulk load?
What is the difference between stop and abort in informatica
what is bridge tables in informatica
what are the deliverables?in your project?
What is a poling?
Is LOAD MANAGER AND LOAD BALANCER same in informatica?
lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?
what is mean by grouping of condition column in lookup transformation?
Is there any target staging area in informatica not staging area
can any one explain me about junk dimension
What is event and what are the tasks related to it?
Teradata 
