How to Implement full outer join in DS using QT ?

[Former Member]

Hi Gurus,

I think we could do it by using 2 query transforms connected with 2 sources and implemented left and right outer joins in every table then Merge together using Merge Transform then using another Q Tr de duplicating the records, that's it. I think this may not be a best practice, if there is any other way to achieve Please guide me on the Topic, it will be grt.

Thank U,

Bhoyer.

[Former Member · Accepted solution]

Hi Santhosh,

Go with that you are planning to do, thats the way. BODS does not have right outer join but I got what you meant to say

Lets take it as Table A full outer join with Table B.

Soution:

Query 1 - A left outer join B

Query 2 - B left outer join A

Merge data from Query1 and Query2

Remove duplicates

[Former Member · Accepted solution]

Hi Sweekriti,

Thank you for ur reply.