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

 

Backup and recovery introduction

 what is persistence layer?

persistence layer is required to ensure that the HANA system can be restarted or restored back to the last consistent state in case of a power failure or abrupt shutdown or system failure.

    Database data is stored 2 places:

         1. Data volumes.
         2. Log volumes.


1.Data volume:

    It contains system data, Application data and undo logs
    it write data in Async mode.

    

2. Log volume:

Redo logs store the changes to the data (insert, update , Delete).

Synchronous writes on commit.

Savepoint: changed data and undo logs are written from memory to disk.

                     default every 5 minutes

                     Automatic execution.

to take complete backup of system, need 3 things:

1.  Complete backup.
2.  incremental / differential backups.
3. Most recent log entries from the log area.