Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sanjaygupta1981
The Informatica supports the following types of joins:
• Normal
• Master Outer
• Detail Outer
• Full Outer
Normal join: discards all the rows of data from the master
and detail source that do not match, based on the condition.
SELECT * FROM employees, departments WHERE
employees.department_id = departments.department_id
Master outer join: discards all the unmatched rows from the
master source and keeps all the rows from the detail source
and the matching rows from the master source.
SELECT * FROM employees LEFT OUTER JOIN departments ON
(employees.department_id = departments.department_id)
Detail outer join: keeps all rows of data from the master
source and the matching rows from the detail source. It
discards the unmatched rows from the detail source.
SELECT * FROM employees RIGHT OUTER JOIN departments ON
(employees.department_id = departments.department_id)
Full outer join keeps all rows of data from both the master
and detail sources.
SELECT * FROM employees FULL OUTER JOIN departments ON
(employees.department_id = departments.department_id)
| Is This Answer Correct ? | 23 Yes | 1 No |
Post New Answer View All Answers
What are the uses of etl tools?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
Explain the features of connected and unconnected lookup.
How to improve the performance of a session using sorter transformation?
What is the way to execute pl/sql script using informatica mapping?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What is the difference between Active and Passive transformation?
How does a rank transform differ from aggregator transform functions max and min?
How do you load only null records into target? Explain through mapping flow.
Quickly characterize reusable change?
What are the different options available for update strategy?
Why is sorter an active transformation?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
