There is an excellent series of short videos that introduce the native data store object (NDSO) for HANA. The NDSO can be considered as a more intelligent table that, in particular, allows to capture deltas. This is especially useful when data is regularly loaded to be transformed or cleansed afterwards: rather than going through the complete data set in the table, one can focus on the changes since the last transformation or cleansing has happened. This reduces the amount of data that needs to be processed and, thus, increases the throughput / performance of the process. Frequently, the effect is significant. The DSO idea has originated from SAP’s Business Warehouse (BW) and has seen the advent of the more versatile and powerful advanced DSO (ADSO) in BW/4HANA.
Here are 4 videos as an introduction to the NDSO:
- SAP HANA Academy – DWF: Native DSO – Introduction (1/4)
- SAP HANA Academy – DWF: Native DSO – Creating an NDSO (2/4)
- SAP HANA Academy – DWF: Native DSO – Preparing for Data Load (3/4)
- SAP HANA Academy – DWF: Native DSO – Loading an NDSO using a FlowGraph (4/4)