Right Outer join

 

--------------------------------------------------------------------------------------

/* The table 1 has 78 rows

   the Business partner table has 45 rows*/

Select * from "<Drop and Drop table 1 from HDI>" as A                                   

Right outer join "<Drop and drop table 2 from HDI>" as B                                

On A."<Foreign_key name of table A>" = B. "<Foreign_key name of table B>"

----------------------------------------------------------------------------------------

Left Outer join

..................................................................................................................................................................

/* The table 1 has 78 rows

   the Business partner table has 45 rows*/

Select * from "<Drop and Drop table 1 from HDI>" as A

Left outer join "<Drop and drop table 2 from HDI>" as B

On A."<Foreign_key name of table A> = B. "<Foreign_key name of table B>"

..................................................................................................................................................................... 

Inner join syntax

 

......................................................................................................................................................................

/* The table 1 has XX rows

   the table B has YY rows*/

Select * from "<Drop and Drop table 1 from HDI>" as A

Inner join "<Drop and drop table 2 from HDI>" as B

On A."<Foreign_key name of table A>" = B. "<Foreign_key name of table B>"

....................................................................................................................................................

HANA Modeling

 

1. Inner join: http://basisbynaveen.blogspot.com/2022/09/inner-join-syntax.html                                 
2. Left Outer: http://basisbynaveen.blogspot.com/2022/09/left-outer-join.html                                     
3. Right Outer Join: http://basisbynaveen.blogspot.com/2022/09/right-outer-join.html                         
4. Full Outer Join: http://basisbynaveen.blogspot.com/2022/09/full-outer-join.html                             
5. Referential Joins: http://basisbynaveen.blogspot.com/2022/09/referential-joins.html                      

6. Employee dimension calculation view :

7. http://basisbynaveen.blogspot.com/2022/09/employee-dimension-calculation-view.html
8. Calculated column with 2 projections and 1                                                                                          join: https://basisbynaveen.blogspot.com/2022/09/calculated-column-with-2-projections.html
9. Different types of Nodes: https://basisbynaveen.blogspot.com/2022/09/different-types-of-nodes.html                                                                                                                                            
10. Restricted column: http://basisbynaveen.blogspot.com/2022/09/restricted-column.html                  
11. Smart Data Integration (SDI) & Smart Data Access (SDA) introduction and installation :   https://basisbynaveen.blogspot.com/2022/09/smart-data-integration-sdi-smart-data.html    
12. Importing data and Build your own models: https://basisbynaveen.blogspot.com/2022/09/importing-data-and-build-your-own-models.html        
13. Create HANA DB remote connection: https://basisbynaveen.blogspot.com/2022/09/create-hanadb-remote-connection.html
14. Create MTA (Multi Target Application) project: https://basisbynaveen.blogspot.com/2022/09/create-mtamulti-target-application.html
15. UAA setup - Access between tenant and HDI: https://basisbynaveen.blogspot.com/2022/10/uaa-setup-access-between-tenant-and-hdi.html
16. 
    

tunning with saptune