Table context menu has import, export load, reload and merge options

[Former Member]

Table context menu has import, export load, reload and merge options, what is the purpoe having them here with table.

when we have the same options via file menu and quick launch.

what happens if i do load or reload? and merge to do what?

Thanks a lot for the helpful info.

[Former Member · Accepted solution]

Load - To load table data from the persistent disk storage into In-memory. If no data is in-memory and you run a query on top of the table, the relevant data is brought into the memory anyway. However, to improve initial runtime, you have this option to pre-load the entire table into the memory

Unload (It is not reload) - This is to do the reverse, if you do not want a table to be offloaded from memory

Merge - When you load delta data into a column store table, it is very expensive to write into a compressed column storage (already loaded data lies in the main store). To overcome this, data is written into something called a delta store which is uncompressed initially. When the merge option is selected, data from the delta store is merged with the main store. Also note that you can turn ON the Auto Merge option and the merge will run periodically.

This document here explains the merge process in detail - http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/10681c09-6276-2f10-78b8-986c68efb...

Import and Export options in the Quick launch have far more options than what is available from the context menu on a table.