Skip to Content
0

extra record in the source pack of a delta dtp

Jan 23, 2017 at 11:54 AM

69

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

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

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.

Share
10 |10000 characters needed characters left characters exceeded
Koen Hesters Jan 23, 2017 at 01:45 PM
0

Hi,

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

Grtz

Koen

Share
10 |10000 characters needed characters left characters exceeded