Delta Records Are Missing

[Former Member]

Hi All,

I am using DS 0FI_GL_10 to load data into DSO and then into cube. Both extractions are delta loads.

Data is populating properly to DSO(Delta load). While loading data from DSO to cube(delta load) few records are always missing. If we do repair full from DSO to cube then missing records are populating.

Can any one let me know the reason of this issue? Or let me know how to do the analysis for this issue?

Thanks,

Subodh

[RamanKorrapati · Accepted solution]

Hi,

You need to cross verify your delta settings/filter at dtp level.

if you ran your init dtp for particular selections or settings then delta load will load the delta records based on your init settings.

What kind of records your missing, can you look at the records which are missing in daily loads.

if you observe daily missed delta records you may find some similarities.

Thanks