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

Full load and Delta Load

We are testing our process chain to load the MasterData. I only select four InfoObjects by using Delta Update. All others are selected Full Update. I found out something that I couldn't explain for Full Update. Here is the example:

Data Source Item - PSA contains 3 request ID (each one contains 4 records only).

I loaded four times today. When I clicked Manage for the InfoObject Item, I saw:

RequestID Date Transferred Added

004 1/9/07 24 24

003 1/9/07 16 16

002 1/9/07 8 8

001 1/9/07 4 4

Only the first time load appears the right numbers of records for Item. I checked the MasterData for Item, it has only 4 records. But why it said 24 records get added? Can anyone explain? Thanks!

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 09, 2007 at 07:35 PM

    <i>PSA contains 3 request ID (each one contains 4 records only).

    I loaded four times today</i>

    Not sure my reasoning is correct..

    first request--4 records

    second request-- 4 records

    third request --4 records

    you have loaded 4 times..

    first time load--> 4 records that needs to be loaded.

    second time load--> 4 records that needs to be loaded + 4 records that are already in PSA again from first request you loaded.(8 records second time)

    third time load--> 4 records that needs to be loaded+8 records (second time load in PSA) + 4 records from first time = 16 records (third time)

    fourth time load-->no new set 0 records + 12 ( third time) + 8 (second time)+4 from first load in PSA = 24 (fourth time)

    which lead to :

    RequestID Date Transferred Added

    004 1/9/07 24 24

    003 1/9/07 16 16

    002 1/9/07 8 8

    001 1/9/07 4 4

    Regards

    Manga

    Message was edited by:

    Manga

    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.