gssharma_msc

 Profile Answers by gssharma_msc Questions by gssharma_msc

• Feb 28th, 2008

 

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.