Show TOC

Setting the DataStore Object TypeLocate this document in the navigation structure

Use

The following decision tree is intended to help you set the right DataStore object type for your purposes: The decision nodes are formed by 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 via the load process. In this case, the data is provided via APIs. See also: APIs of the DataStore Object for Direct Update.

If the data will be provided via 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 Duplicate Data Records flag if you want to use the following functions:

    • Single record reporting

Note the following with regard to determining the DataStore object type: Performance Tips for DataStore Objects.

You can find more information about DataStore object types under:

Standard DataStore Object

Write-Optimized DataStore Objects