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
Can anyone tell me the new features in Informatica 9 Version?
Explain 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?
How to generate sequence numbers?
Could you explain what is enterprise data warehouse?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
How to load the name of the current processing flat file along with the data into the target using informatica mapping?
How is union transformation utilized?
How can we use batches?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What are the conditions needed to improve the performance of informatica aggregator transformation?
Is it possible to define a single node as a Gateway node as well as worker node?
Informatica Checkpoints
Define the various join types of joiner transformation?
What is an Integration service in Informatica?
Differentiate between sessions and batches?
