The following decision tree is intended to help you define the right DataStore object type for your purposes: The decision nodes represent the following functions and properties:
● Data provision with load process:
Data is loaded using the data transfer process (DTP).
● Delta calculation:
Delta values are calculated from the loaded and activated data records in the DataStore object. These delta values can be written to InfoCubes, for example, by delta recording.
● Single record reporting:
Queries are run based on DataStore objects that return just a few data records as the result.
● Unique data:
Only unique data records are loaded and activated for DataStore keys. Existing records cannot be updated.
The graphic shows that a DataStore object must be used for direct updating if the data is not provided using the load process. In this case, the data is provided with APIs. More information: DataStore Objects for Direct Update.
If the data is provided using the load process, you need a standard DataStore object or a write-optimized DataStore object, depending on how you want to use it. We make the following recommendations:
● Use a standard DataStore object and set the Unique Data Records flag if you want to use the following functions:
○ Delta calculation
○ Single record reporting
○ Unique data
● Use a standard DataStore object if you want to use the following functions:
○ Delta calculation
○ Single record reporting
● Use a standard DataStore object and set the Create SIDs on Activation and Unique Data Records flags if you want to use the following functions:
○ Delta calculation
○ Unique data
● Use a standard DataStore object and set the Create SIDs on Activation flag if you want to use the following function:
○ Delta calculation
● Use a write-optimized DataStore object if you want to use the following function:
○ Unique data
● Use a write-optimized DataStore object and set the No Check on Uniqueness of Dataflag if you want to use the following function:
○ Single record reporting
More information about defining the DataStore object type: Performance Optimization for DataStore Objects.
More information about DataStore object types:
Write-Optimized DataStore Object