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
Target increases every day even though no new record was inserted
Difference between Data and Index Caches?
what is song in infrmatica...?
What is dimensional table? Explain the different dimensions.
can you please explain me pre session and post session options?
What are the modules in Power Center
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What are the differences between source qualifier and joiner transformation?
What is source qualifier transformation in informatica?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
Can we override a native sql query within informatica?
What is a transaction control transformation?
what is diff b/t sorter t/r and agg have the option sorter property...
What are Dimensional table?
What is blocking transformation?
