Data Integration Interview Question:

Explain how Full Outer Join is implemented BODI?

Submitted by: Administrator

- 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.
Submitted by: Administrator