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)

Enlist some properties of sessions.

0 Answers  

Why is meant by direct and indirect loading options in sessions?

4 Answers  

Plz..let me know differences between Informatica 7.1 and 8.1?

3 Answers  

what is the process of target load planing?

2 Answers   IBM,

How can u insert o ne row in the target if that row does not exists in the target and update if it exists

6 Answers   Accenture,

How can we improve session performance in aggregator transformation?

0 Answers   Informatica,

What is an aggregator transformation? it is active why cant it be passive explain?

3 Answers   HCL,

In joiner, how to load Master table in Target?

2 Answers  

Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.

0 Answers   TCS,

Does an informatica transformation support only aggregate expressions?

0 Answers  

Mention few advantages of router transformation over filter transformation.

0 Answers  

In which transformation you cannot drag ports into it?

0 Answers   Informatica,