Skip to Content
avatar image
Former Member

extra record in the source pack of a delta dtp

Hello Experts !

I am facing a very unusual issue in a regular delta load from a Standard DSO to a Infocube.

When the delta load is running ; there are 2 records being passed to the source package of the DTP ; while the active table to the DSO contains only a single record only for a particular key combination .

Also the point to be noted is this second record is an exact replica of the record from the active table of the DSO ..

When I run a full load for the same key combination record only a single record(as expected) in inserted into the source package ...

I debugged the transformation but it is impossible to track this extra record ..

Please provide your thoughts about this scenario.

Thanks in advance !!

Regards,

Shivani

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jan 24, 2017 at 08:03 AM

    Hi,

    Yes it will pass 2 records (Before image and after image) in delta. Check the below link for explanation .

    http://explore-sapbw.blogspot.ae/2012/04/how-does-dso-maintains-delta-records-in.html

    Regards.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 23, 2017 at 01:45 PM

    Hi,

    Delta loads from DSO to Cube are based on the logtable of the DSO, not the active table.

    Grtz

    Koen

    Add comment
    10|10000 characters needed characters exceeded