Why Tranferred record number and Added record number are different for Delt

[Former Member]

We perform Initial/Delta loads to an ODS. We check the manage of this ODS and find the Tranferred record number and the Added record number are the same for Initial load, but not for Delta loads that the number of Transferred records is always greater than the number of the Added records for each Delta load. Could someone explain why?

Thanks!

[Former Member · Accepted solution]

Hi,

this is because and ODS has a "key". All records loaded having the same KEY than an existing record will replace it according to your update rule of the data fields (overwrite or addition).

For the first load if there isn't any record with the same ODS key, the number of loaded records will match the number of activated records because the ODS is empty.

In all successive loads, loaded records might already exists (with the same key) in your ODS. Even within the same load, you could have two records with the same ODS key... in that case the last loaded will win (ovrwrite the provious one).

hope this clears your doubts...

Olivier.

[Former Member · Accepted solution]

hi All,

Thanks for answering our question and now we understand!

We have one more 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,

that's what I explained: most likely in your initial load you had already records having the same ODS key.

Loaded records = 4'000

New Table = 4'000 (same than extracted if no deletion/adding of records is performed in routines)

Active Table might get less if you have records with the same ODS key...

hope this helps...

Olivier.

[Former Member]

Hi Kevin,

We cannot generalize this way, it depends on what is happening in your update rules.

And also the Changed Records images.

CK

Message was edited by:

Chitrarth Kastwar

[former_member188325]

while doing Delta load,only changed records will be added.Changed records can not be more than total records.So you will see added records alwys less than transferred records.