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)

what is a junk dimension ?

14 Answers   Atos Origin, Cognizant, HS, NIIT, TCS,

i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me

2 Answers  

What can we do to improve the performance of informatica aggregator transformation?

0 Answers  

i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?

9 Answers   Cap Gemini,

define galaxy repository in informatica

0 Answers  

Make a note of the quantity vaults made in informatica?

0 Answers  

tell me the push down optimization

2 Answers   Wipro,

Differentiate between reusable transformation and mapplet.

0 Answers  

Hi, This is Ranadheer. How to load fact tables using dimeension tables. Please anyone give me a answer with example. Thanks in Advance.

1 Answers  

How to use pmcmd utility command?

0 Answers  

Why we use stored procedure transformation?

4 Answers  

explain different types of modeling.

2 Answers