Skip to Content
author's profile photo Former Member
Former Member

"Only Get Delta Once" - How to use this correctly?

Hi folks,

we are currently facing the following situation:

We have a data source only being able to deliver full update.

That's why we proceed as follows:

1.) Full-Load with Infopackage to PSA

2.) Delta-Load with DTP from PSA to first-level-DSO (write-optimized)

3.) Delta-Load with DTP from first-level-DSO to second-level-DSO (standard-DSO). As the activation aggregates all duplicate entries, we are therefore able to deliver a delta to all following data targets (e.g. infocubes)

What we are now wondering about how to use the flag "Only Get Delta Once" which is available in all Delta-DTPs. The help explains it should be used when creating snapshot-scenarios like ours as each request is only delivered once, even if it gets deleted in the data target.

But what other benefit would we have when setting this flag? As I mentioned, the snapshot-scenario also works without this flag...

Could anyone perhaps provide me some more details about this flag and where it should be used?

Thanks & regards

bivision

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    Posted on Mar 23, 2009 at 01:00 PM

    Hi, please check the following link which explains this matter.

    [Creating Data Transfer Process|http://help.sap.com/saphelp_nw70/helpdata/EN/42/fa50e40f501a77e10000000a422035/frameset.htm]

    Thanks,

    Walter Oliveira.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 23, 2009 at 12:29 PM

    Hi,

    Plz check the below blog:

    /people/community.user/blog/2007/06/21/sap-netweaver-70-bi-data-transfer-process-with-147only-get-delta-once148

    May be its useful

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 23, 2009 at 12:56 PM

    Hi,

    If you select the option 'Only get delta once', then every request in the PSA will only be loaded into the Data target once. For example. If you load a full request into the PSA through an InfoPackage and then load it to the Cube. In a snapshot scenario, when the new full load comes to the PSA you will need to delete the previous request from the cube before loading the new request.

    But if you delete the previous request from the cube, and not from the PSA - and if you haven't checked the 'Only get delta once' flag, when you execute the DTP, it will load both previous and the new requests from the PSA to the cube. In order to avoid this you have 2 options:

    1. You can delete a request from the PSA after every successful load into the Cube OR

    2. You can check the 'Only get delta once' flag in the DTP so that it won't load any request it has loaded into the cubes previously even if it was deleted from the cube.

    Using the second option de-couples the PSA maintenance from your regular data loading and also saves you an additional step of deleting the PSA request in your process chain.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 02, 2013 at 11:35 AM

    Say I have request 640,641 and 642 in my infocube then

    i have 640,641,642,643 in my PSA.

    If there get delta only once option then what data will be present in my IC?

    1. Do I need to delete old requests in IC before loading the 643 request.

    2. Will only 643 come in my IC?

    Also if in PSA 644 request comes then what will be the scenario?

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.