Answer / ravindra.15aug

Normally four joins in Informatica
1) Normal join
2) Master join
3) Detail join
4) Full outer join

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)

Answer / srinivas

there are four types of joins in Informatica
1) Normal join
2) Master join
3) Detail join
4) Full outer join

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

Answer / maj

In this select query I think instead of LEFT OUTER
JOIN,Need to put "RIGHT OUTER JOIN"

SELECT * FROM employees LEFT OUTER JOIN departments ON
(employees.department_id = departments.department_id)

Explain reference cursor?

1 Answers  

What are session parameters ? How do you set them?

0 Answers  

Is it passive or active when check and uncheck the box of DISTINCT in Sorter transformation? why?

6 Answers   iFlex, Morgan Stanley,

What is a surrogate key?Why we use it in a mapping?Pl give an example.

4 Answers   PCS,

What is Java Transformation? what are the uses of it?

0 Answers   TCS,

What is the Hierarchy of DWH?

1 Answers  

When you move from devel to prod how will you retain a variable

1 Answers  

Hi All, I've 110 records in my table but 101 records contains an error. When I run the session, I want to load the 100 records into the target. Can anyone suggest me the best solution for this... Thanks in Advance,

7 Answers   Tech Mahindra,

In which transformation you cannot drag ports into it?

0 Answers   Informatica,

what is the difference between informatica6.1 and infomatica7.1

0 Answers   TCS,

Please let me know how to make Data masking in informatica..

0 Answers  

What is a sorter transformation?

0 Answers   Informatica,