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 load a Dimension ? and how to load a fact table?

0 Answers  

How can you use an Oracle sequences in Informatica? You have an Informatica sequence generator transformation also. Which one is better to use?

1 Answers  

how can send duplicate records to one tableand non duplicate records to one table with simple clear mapping?

5 Answers   DELL,

How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)

6 Answers   Puma,

in what type of scenario bulk loading and normal loading we use?

2 Answers   Cognizant, Wipro,

How can i set break points in debugging mode ? can explain steps please?

1 Answers   ABC, TCS,

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

2 Answers   TCS,

Explain the aggregator transformation?

0 Answers  

What does update strategy mean, and what are the different option of it?

0 Answers  

What is an unconnected transformation?

0 Answers   Informatica,

Can we use the mapping parameters or variables created in one mapping into another mapping?

1 Answers   Informatica,

There are 4 source files which contains same metadata create target that should display the file name along with record please send answer with mapping

3 Answers   Wipro,