- Full Outer Join is implemented by using SQL Transformation and writing custom query.

- Following example describes SQL Transformation to implement Full Outer Join:

select emp.*, dept.deptname, dept.deptno dno, dept.location from scott.employee emp

FULL OUTER JOIN

scott.department dept on (emp.deptno = dept.deptno) ;

- Following example illustrates custom query to implement Full Outer Join:

1. Drag EMPLOYEE, DEPARTMENT tables as src.

2. Place the query transform for performing the Left Outer Join.

3. Place one more query transform for performing the Right Outer Join.

4. Merge and load them into the target.