Skip to Content
Author's profile photo Former Member

How to create “Full Outer Join” in SAP BODS

Picture1.jpg

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).

Assigned tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Ahalya Inturi
      Ahalya Inturi

      Hi

       

      Have a query .. Is there an option for right outer join in QUERY TRANSFORM ?

      Author's profile photo Dirk Venken
      Dirk Venken

      No, there isn't. But you can swap the sequence of your join tables: A left join B is identical to B right join A.