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 is a joiner transformation?
What is transformation?
EXL informatica Questions
What is union transformation?
Differentiate between sessions and batches?
What is the difference between a repository server and a powerhouse?
In how many ways we can create ports?
Please let me know how to make Data masking in informatica..
what is degenerated dimension?
Explain lookup transformation is active in informatica
What is the reusable transformation?
Explain what are the different types of transformation available in informatica.
What is the maplet?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
Explain the scenario which compels informatica server to reject files?
