Full Outer Join in Informatica

Informatica Full Outer Join

The Full Outer Join in Informatica is another option available in Joiner Transformation which is used to return all the existing records from Master table and Detail table. Let us see the visual representation of the Full Outer Join in Informatica for better understanding. In this article, we are going to perform Full Outer Join … Read more

Detail Outer Join in Informatica

Informatica Detail Outer Join

The Detail Outer Join in Informatica is used to return all the existing records from Master table and only matching records from Detail table. Let us see the visual representation of the Detail Outer Join in Informatica for better understanding. In this article, we are going to perform Informatica Detail Outer Join on two SQL tables … Read more

Master Outer Join in Informatica

Informatica Master Outer Join

The Master Outer Join in Informatica is used to return all the existing records from Details table and only matching records from Master table. Let us see the visual representation of the Master Outer Join in Informatica for better understanding. In this article, we are going to perform Informatica Master Outer Join on two SQL tables … Read more

Joiner Transformation in Informatica

Normal Join in Informatica

The Joiner Transformation in Informatica is used to perform SQL Joins. There are four types of Joins in Informatica, and they Inner Join (Normal Join), Master Outer Join, Detail Outer Join and Full Outer Join. Joiner Transformation in Informatica is very useful to load data into the Dimension tables in Data Warehouse. Normal Join: The … Read more