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
Explain the pipeline partition with real time example?
Mention a few design and development best practices for informatica?
What are data-driven sessions?
What does update strategy mean, and what are the different option of it?
What is data transformation manager process?
Explain the difference between a data warehouse and a data mart?
How can we update a record in the target table without using update strategy?
can u give example for factless fact table
What are the different options available for update strategy?
How many input parameters can exist in an unconnected lookup?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What is the scenario which compels informatica server to reject files?
What is meant by a domain?
As union transformation gives UNION ALL output, how you will get the UNION output?
Sequence generator, when you move from develoment to production how will you reset
