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 $$$$?
Enlist some properties of sessions.
Define update strategy?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
tell me 5 session failure in real time how can you solve that in your project?
How to do unit testing in informatica?
what is unit testing?tell me proceedure
What is joiner transformation?
How to generate or load values in to the target table based on a column value using informatica etl tool.
Explain direct and indirect flat file loading (source file type) - informatica
How can we delete duplicate rows from flat files?
What is workflow manager?
Define the various join types of joiner transformation?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
Differences between version 7.x and 8.x.
