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
What is the difference between writing a joiner query in ANSI style and THETA style?
Define filter transformation?
How are the sources and targets definitions imported in informatica designer?
How to elaborate powercenter integration service?
How does a rank transform differ from aggregator transform functions max and min?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
How to generate or load values in to the target table based on a column value using informatica etl tool.
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Explain how many types of dimensions are available in informatica?
Can we create multiple integration service on single repository?
What is a joiner transformation and why it is an active one?
How can we remove the duplicates from flat file source?
What is source qualifier transformation in informatica?
How do you load alternate records into different tables through mapping flow?
