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 the difference between router and filter?
Is there any way to read the ms excel datas directly into informatica?
How to load last n records of file into target table - informatica
What is the format of informatica objects in a repository?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Explain the types of lookup transformation?
How do you load first and last records into target table?
what is Active lock explain
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
differences between service based and product based?
What are the measure objects?
What are pre and post-session shell commands?
What is dynamic cache?
wf dont have integration severances how you can run?
Explain the tuning lookup transformation - informatica
