Implementing a Full outer join

Asked By centic branson 60 points N/A Posted on - 04/14/2012

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

• Status: Open
• Question Views: 1188
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: C++

Answered By Ljupcho Rano 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

FULL OUTER JOIN

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.

About Ljupcho Rano

Questions
3

Answers
7

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 04/28/2012
• Question Category: C++