How to create "Full Outer Join" in SAP BODS

[Former Member]

Although this can be done directly by using the "SQL Transform" by providing the query for full-outer-join, but it is said that its not recommended due to performance reasons.

So the picture explains itself how to perform the same. We have two source tables, One Query transform contains the contents for left-outer-join and the another Query transform contains the contents for right-outer-join . Then the outputs from both Query transforms are merged (union-all) , and then we remove the duplicate rows by using another query transform (Query_2) and the output is directed to the output table (TEST_OUTPUT).