Why the number of records shown in the Contents tab is less than the Added

[Former Member]

We have one question for SRM (new release is called SRM and the old release is called EBP) Shopping Cart ODS load. Right click this ODS and then manager this ODS, then we can see 1st two tabs are Contents and Requests respectively. Check the 2nd tab Request, there is a column Added record which should be the new records added to this ODS and it's Added record number for initial load is, e.g., 4000. But if we check 1st tab Contents, and then click Active data button and then click Number of Entries button, it shows 3000. Why the number of records shown in the Contents tab is less than the Added records for Initial load shown in the Request tab for this SRM Shopping Cart ODS?

Thanks!

[Former Member · Accepted solution]

Hi Kevin,

This happens because of Data Activation Process, before it reaches Active Data Table of ODS. Here Records with same key are suppressed.

The explanation was already given in previous post.

For example you New Data Table of ODS receives following records

Customer material Key Figure Image

A B 10 N (New Image)

A B -10 X (Before Image)

A B 20 " " (After Image)

Only one record will be added in Active Table the last one.

A B 20 " " (After Image)

This is one of the reason.

Hope this helps

Thanks

CK

[Former Member]

Hi,

it is not necessary to update all the records extracted from source system, because Data trasformation will be there at update rule and trasfer rule.

Records may increase or reduced also.

Regards,

Vish.