Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
Global and Local shortcuts. Advantages.
What is the need of an ETL tool?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Is there any way to read the ms excel datas directly into informatica?
what is the difference between informatica6.1 and infomatica7.1
What are the tasks that can be performed using sq?
Which transformation should we use to normalise the COBOL and relational sources?
What is a pre-defined event and user-defined event?
What are the differences between source qualifier and joiner transformation?
How to extract sap data using informatica? What is abap? What are idocs?
What are the restrictions of union transformation?
What is a standalone command task?
How we can create indexes after completing the loan process?
Explain sessions and how many types of sessions are there?
What is a filter transformation and why it is an active one?
