How many joins in Informatica
- 5 Answers
- 22790 Views
- CSC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ravindra.15aug
Normally four joins in Informatica
1) Normal join
2) Master join
3) Detail join
4) Full outer join
| Is This Answer Correct ? | 38 Yes | 2 No |
Answer / 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 |
Answer / srinivas
there are four types of joins in Informatica
1) Normal join
2) Master join
3) Detail join
4) Full outer join
| Is This Answer Correct ? | 13 Yes | 2 No |
Answer / srinivas
there are four types of joins in Informatica
1) Normal join -- Equi join
2) Master join -- Left outer join
3) Detail join -- Right outer join
4) Full outer join -- Full outer join
| Is This Answer Correct ? | 9 Yes | 7 No |
How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?
what is the diff b/w target load plan and cbl?
Examples of Fatal & Non-Fatal error?
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
How to improve the performance of a session using sorter transformation?
How can we update a record in the target table without using update strategy?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
How many types of sessions are there in informatica.please explain them?
where to select code page option?
What are Dimensions and various types of Dimensions?
Define Pmrep command?
what is the difference between repository & Intergration service
Teradata 
