Answer Detail: RE: How do you implement Full outer join

GeekInterview.com > Interview Questions > Data Warehousing > Data Integration

Print |

Question: How do you implement Full outer join

Answer: How we will implement Full outer join in BODI?Explain with some examples?

February 02, 2008 06:33:15	#1
gssharma_msc	Member Since: January 2007 Total Comments: 4
RE: How do you implement Full outer join
You can acheive this by two methods 1. Use SQl transformation and write your own query 2. First apply right outer join and then left outer join and merge it. Ex:- 1. select e.*, d.dname, d.deptno dno, d.loc from scott.emp e FULL OUTER JOIN scott.dept d on (e.deptno = d.deptno) 2. Drag EMP,DEPT tables as src, now place query transform to perform left outer join now place another query transform to perform Right outer join. 2.1 Merge it and load it into the target.