Question Re: How to use Delta functionality in Write optimize DSO in Technology Q&A

How to use Delta functionality in Write optimize DSO

Former Member — Sun, 10 Apr 2016 18:28:28 GMT

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

Re: How to use Delta functionality in Write optimize DSO

Loed — Mon, 11 Apr 2016 01:18:40 GMT

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

Re: How to use Delta functionality in Write optimize DSO

Former Member — Mon, 11 Apr 2016 02:27:51 GMT

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.

Re: How to use Delta functionality in Write optimize DSO

Former Member — Mon, 11 Apr 2016 04:28:04 GMT

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

Re: How to use Delta functionality in Write optimize DSO

Former Member — Mon, 11 Apr 2016 19:29:31 GMT

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