SAP BW - HANA - How to perform Delta Merge manually.


If you want to perform Delta Merge manually, You can use below ways.

   1. Using menu:  
  1. In the Systems view, navigate to the table.
  2. In the context menu of the table, choose Perform Delta Merge.
  3. Choose OK.
   2. Using SQL: run the below SQL.

         MERGE DELTA OF '<table_name>'

To check the history of delta merge of a table... read more.

for more details on delta merge: http://sapway.com/WILLSYS/HANADB/deltamerge.pdf