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 new features of Power Center 5.0?
What are the differences between a connected lookup and unconnected lookup?
How do you handle two sessions in Informatica
How to create or import flat file definition in to the warehouse designer?
Whats there in global repository
what are the Methods For Creating Reusable Transformations?
What could be the possible resons of locks by user?
Explain the different dimensions.
What is informatica worklet?
What is rank index in rank transformation?
What are the new features of informatica 9.x in developer level?
What is workflow monitor?
What is a standalone command task?
Explain sessions and how many types of sessions are there?
What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
