Standard DSO vs Optimized DSO

Standard DataStore Objects

A standard DSO has three transparent tables on the database.

1. Activation Queue: Holds the records that are to be updated, not yet been activated.
2. Active Data:Table which holds active data.
3. Change Log:Holds the change history for delta loads.

Process of Data transfer to DSO

• Data gets first loaded into the activation Queue also called the New data table.
• Dataupon “Activation” is transferred from New data table to Active data table
• And then to Change log table. In change log table you can have the changed data or corrected data.

Note: the data in Change log table is redundantly stored and can be deleted after the records have been activated.

Following steps can be used to create Standard DSO,

·         Right click on InfoArea.

·         Enter the Technical Name.

·         Click on the “Create” button.

Configure the following settings in the DSO,

·         SID Generation upon Activation :Generated the Surrogate ID (SID) for each master data value, when this option is checked.

·         Set Quality Status to “OK” Automatically:·         Activate Data Automatically: DSO activation is automated by using this setting.

·         PSA receives data unchanged to the Source system

·         Data is posted to Corporate memory write –optimized DSO from pass thru write-optimized DSO

·         It is used for initial staging of source system data.

·         Data loads can be faster since it does not have the separate activation step.

·         Every record has a technical key and hence aggregation of records is not possible. New records are inserted every time.