Full vs. Delta Load

[#1]

Hi BI-Experts!

This is a rather general question.

Is there a recommendation when to use Full or Delta Load?

I know the functional differences but do SAP or some technical reasons say that each of them may only be used in special cases?

For example Delta Load can only be used with SAP source systems?

Best regards,

Philipp

[Former Member]

Hi Landmann,

I just need some more information on this. What will happen if we do load twice?. I mean for the first time we do load and later on we do delta load for get the updated and changed data. if, we do full load one again instead of delta load what will happen in target system. In DSO and/ or Cube. Whether it ll replace old data or add with old data?

[RamanKorrapati]

if your understand about full and delta concepts you may not be raised your doubt.

Full load - is one time activity.

Delta load - always loads newly create or changed records from the last update.

if you load full load twice to info cube, it leads duplication. in case  of DSO it overwrites if your key fig property was over write other wise key fig values will be doubled. leads in consistency.