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)

How to update a particular record in target with out running whole workflow?

0 Answers  

What is persistent lookup cache?

0 Answers  

Write the unconnected lookup syntax?

0 Answers  

TWO FLAT FILES ARE THERE , EACH HAVING NO MATCHING COLUMNS . HOW CAN U JOIN THESE TWO USING JOINER TRANSFORMATION ?

6 Answers   HP, TCS,

how to import multiple flat files in to single target where there is no common column in the flat files

2 Answers   TCS,

Differnce between filter and router?

14 Answers   IBM,

Why the UNION TRANSFERMATION is an Active TRANSFERMATION

6 Answers   Emphasis,

Explain sql transformation in script mode examples in informatica

0 Answers   Informatica,

What is the function of union transformation?

0 Answers  

why do we go for update strategy tr in SCD rather using the session properties?

3 Answers   IBM,

What are the types of metadata that stores in repository?

2 Answers  

What is mapping debugger?

0 Answers