what is left outer join?
- 3 Answers
- 7149 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 |
What are the connected or unconnected transforamations?
What is the status code?
Insert else update option in which situation we will use
How your source files are coming to your ETL server. Actually at which stage of your mapping it is happen.
If I have set the property Treat Source Rows as Insert and for the target properties I have checked the boxes Update as Update, what will happen to incoming rows? What exactly is the use of these check boxes and in which scenarios we use them. Also what is the sequence in which informatica understands these properties.Does it takes whatever is defined in treat source rows as property or it is in any other way. Please explain.
Repository user profiles
What is joiner transformation in informatica?
111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?
write a query to get maximum salary from the employers table without duplicates....kindly help me
What is the difference between OLTP and ODS?
What are the uses of a Parameter file?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
Teradata 
