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

SAP HANA - How to check the last DELTA MERGE performed on SAP HANA table

If you want to check the time stamp when was the last time delta merge done for a table in SAP HANA.

You can follow below simple steps.

1. Go to tables in Catalog.
2. Right click and apply filter to find quickly.
3. Double click on the table.
4. Go to Runtime Information.
5. Details will be shown on delta size and last delta merge and other details.

You will see details as below screenshot.

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>'


for more details on delta merge:

http://sapway.com/WILLSYS/HANADB/deltamerge.pdf