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
Design time, run time. If you don't create parameter what will happen
Separate from an archive server and a powerhouse?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
While importing the relational source definition from the database, what are the metadata of source that will be imported?
How do we call shell scripts from informatica?
Briefly describe lookup transformation?
What is the status code in stored procedure transformation?
waht type of interface is used for testing the data in informatica
In informatica workflow manager, how many repositories can be created?
Define pmcmd command?
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
draw informatica architecture 8.6 ?
What is a stored procedure transformation?
How to generate or load values in to the target table based on a column value using informatica etl tool.
what are the different types of transformation available in informatica. And what are the mostly used ones among them?