Implementing a Full outer join

Asked By 60 points N/A Posted on -

How do you implement a full outer join in Business Object Data Integrator?

Answered By 0 points N/A #147889

Implementing a Full outer join


Hi There,

There are two methods for implementing.

1st we will apply right outer join and then we will apply left outer join and then merge it.

E.g. Select e.* , d.dname, d.deptno dno, d.loc from scott, emp e


Scott dept d on (e.deptno = d.deptno)

E.g. Drag EMP, DEPT tables as src, now place query transform to make the left outer join then place another query transform to make a right outer join.

Hope this will helpful for you.

Login/Register to Answer

Related Questions