Updating DSO

Updating DataStore objects involves the data to be loaded isavailable immediately for further processing. It requires writing Optimized DSOto provide a temporary storage area for large sets of data if you are executingcomplex transformations for this data before it is written on to the DataStoreobject. The data can then be updated to further INFOPROVIDERs. You only have tocreate the complex transformations once for all data.

Write Optimized DSOs are used as the EDW layer for savingdata. Business rules are only applied when the data is updated to additional INFOPROVIDERs.

In Write Optimized DSO, the system does not generate SIDsand you do not need to activate them. This means that you can save time andfurther process the data quickly. Reporting is possible on the basis of theseDataStore objects.

Structure of Write Optimized DSO

It only contains the table of active data and there is noneed to activate the data as required with the standard DSO. This allows you toprocess the data more quickly.

In Write optimized DSO, loaded data is not aggregated. Iftwo data records with the same logical key are extracted from the source, bothrecords are saved in the DataStore object. The record made responsible foraggregation remains, however, so that the aggregation of data can take placelater in standard DataStore objects.

The system generates a unique technical key for thewrite-optimized DataStore object. The standard key fields are not necessarywith this type of a DataStore object. If there are standard key fields anyway,they are called semantic keys, so that they can be distinguished from the othertechnical keys.

The technical keys consist of −

• Request GUID field (0REQUEST)
• Data Package field (0DATAPAKID)
• Data Record Number field (0RECORD) and you load only new data records.
• Use T-Code: RSA1
• Go to Modeling tab → InfoProvider → Select InfoArea → Right click and click on create DataStore Object.
• Enter the technical name and description of the DataStore object.
• Type of DataStore Object − This is used to select the DSO type. It takes a standard DSO by default.
• Click on Create (F5) button.
• To change the DSO type, go to the settings tab as shown in the following screenshot. Click on the Edit icon and when a new window opens, you can change the DataStore Object and also select the type which is required.