Joiner Transformation

Joiner Transformation:

You can join two tables using the Joiner Transformation. If you need to join 3 table Sources, then 2 Joiner Transformation is required. So if you need to join N number of source, you need N-1 Joiner Transformation.

The Joiner Transformation joins the source based on one or more condition between the 2 sources.

The 2 input source pipeline has master and detail pipeline. By default, the second source is considered as Master.

Mapping Designer

Joiner Transformation Edit- Give the Condition based on 2 source Table

Select Master/Detail for Source

Below query is executed for the above mapping.

select e.employee_id,first_name,d.department_id,d.department_name,e.email from employees e left outer join departments d on e.department_id=d.department_id;

This is otherwise called Normal Join.

Normal Join

Matching rows from master table and detail table

Master Outer Join

Returns the rows from detail table and the matching records of both the table.

Detail Outer Join

Returns the rows from master table and the matching records of both the table.