How to use Delta functionality in Write optimize DSO

[Former Member]

Hi All

I want to know how delta functionality in Write Optimize DSO works .After going though multiple discussion i know that it is based on request from the source but none of them s explained who it work (by any example /pdf/project example )

Please help me on this .I have already spend number of hours in sdn but no avail .Thanks in advance

[Former Member · Accepted solution]

Hello,

Write optimized DSO used to pull large volume of data

) If the Data Source is not delta enabled. In this case, you would want to     have a Write-Optimized DataStore to be the first stage in BI and then pull the Delta request to a cube.

ii) Write-optimized DataStore object is used as a temporary storage area for large sets of data when executing complex transformations for this data before it is written to the DataStore object. Subsequently, the data can be updated to further InfoProviders. You only have to create the complex transformations once for all incoming data.

b. Write-optimized DataStore objects can be the staging layer for saving data. Business rules are only applied when the data is updated to additional InfoProviders.

Delta Mechanism

Write-Optimized Data Store does not support the image based delta, it supports request level delta, and you will get brand new delta request for each data load.

Since write-optimized DataStore objects do not have a change log, the system does not create delta (in the sense of a before image and an after image). When you update data into the connected InfoProviders, the system only updates the requests that have not yet been posted.

Write-Optimized Data Store supports request level delta. In order to capture before and after image delta, you must have to post latest request into further targets like Standard DataStore or Infocubes.

Regards,

Priya M

[Former Member · Accepted solution]

Thanks for the response ,Now i have  a better understanding .do you have any pdf /document so that i can try it in the sand box  system

[Former Member]

WDSO delta works based on technical keys

if use semantic keys, technical keys will be drop delta works based on semantic keys.

uncheck the do not check duplicate records (not allow the duplicates)

if check allow the duplicates.

[Loed]

Hi,

WDSO does not have the "delta" which is similar to Standard DSO..Its delta is based on the requests not yet loaded..

You may refer in these docs..

Prem-(Sap BW Powered Hana): A Few More Tips on Write Optimized DSO

http://learnsapbibasics.blogspot.com/2013/04/when-we-use-write-optimized-dso.html

Regards,

Loed