What is the main difference of Direct update DSO and Write optimized DSO

[Former Member]

What is the main difference of Direct update DSO and Write optimized DSO?

[syed_er1 · Accepted solution]

Hello,

hope this helps:

Write-optimized DataStore object

Data provided using a data transfer process

SID values cannot be generated

Records with the same key are not aggregated

Data is available for reporting immediately after it is loaded

DataStore object for direct update ( mostly used in APD's )

Data provided using APIs

SIDs cannot be generated

Records with the same key are not aggregated

thanks

syed

[Former Member · Accepted solution]

Still I need main difference in the answer?

We can load Direct update DSO and Write optimized DSO thru API's and usage you mentioned as Direct update DSO is for APD's is correct and SID values cannot be generated,Records with the same key are not aggregated are common features..these are all features is common....the only difference is mentioned here is For Write optimized DSO reporting is possible after loading...means

main difference is.....is it reporting is not possible for Direct update DSO? If it is reporting is possible then what is the other difference?

[former_member188011 · Accepted solution]

Hi chandra:

Check this link.

http://help.sap.com/saphelp_nw04s/helpdata/en/f9/45503c242b4a67e10000000a114084/content.htm

You can find another difference on page 147, section "Reclustering DataStore Objects" of the document "Enterprise Data Warehousing"

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/67efb9bb-0601-0010-f7a2-b582e94bc...

>You can only use reclustering for standard DataStore objects and DataStore objects for direct update. You cannot use reclustering for write-optimized DataStore objects. User-defined multidimensional clustering is not available for write-optimized DataStore objects

Regards,

Francisco Milán.

Edited by: Francisco Milan on Aug 11, 2010 7:09 PM

[Former Member · Accepted solution]

Reporting is not possible for a Direct Update DSO. Typically a Direct Update DSO is truncated each time and is used to stage data to move to other data targets, to support calculations/lookups, etc. It also does not maintain request id, etc.

Although I believe you can pull a trick and use it in an InfoSet, thus making it reportable.