Data Integration Question:
Explain how Full Outer Join is implemented BODI?
Answer:
- 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.
- 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.
| Previous Question | Next Question |
| Explain how to adjust the performance of Data Integrator? | Tell me how SNMP Agent is associated with Data Integrator? |