Types of DSO's

Three types of DSO in BI 7.0.

1)Standard DSO

It consists of three tables.......activation queue,active table,and change log table.....It is completly integrated in the staging process.....Using change log table means that all changes are also written and are available as delta uploads for connected data targets.......

Data population is done via the Standard DTP
SID are generated for standard DSO
Data Records with same key are aggregates during activation process for standard DSO.
Needs Request activation process 

2)Write optimized DSO
This is the new Object in terms of NW2004s. It is integrated for warehouse level of architecture..........and has the advantage of quicker loads, has only active data table(with delta capture capability). SIDs are not generate.

This DSO is primarily designed to have as the initial staging of the source systems data and from here the data can be transferred to Standard DSO or Infocube .
 

We can use a write-optimized DataStore object as a temporary storage area for large sets of data if we are executing complex transformations for this data before it is written to the DataStore object. Subsequently, the data can be updated to further (smaller) InfoProviders. we only have to create the complex transformations once for all data.

The system does not generate SIDs for write-optimized DataStore objects, so reporting would be worse compared to standard DSO Object.

Data population is done via Standard DTP
No Need to activate Request

3)Direct update DSO

It is the same as the Transactional ODS Object in BW3.5. It consists of active data table only. This means it is not easily integrated in the staging process...SIDs are not generated ......This DSO type is filled using API and can be read via BAPI......It is generally use for external application and APD. Usually used for SEM. This cannot be used for Delta Transfer to further targets connected, only Full load is possible.

Data population is done via Direct DTP via API's
No Need to activate Request