最近比较空闲,学习了BW350的关于BW增量部分,将一些自己之前比较模糊的概念梳理了一番,顺便做个笔记;
1、Delta Process
R3中通过SE11查看表ROOSOURCE,BW中通过SE11查看表RSOLTPSOURCE可以查看数据源的抽取机制,即对应的几种抽取方式;举例如下所示:
ABR 采用前镜像、后镜像和反转镜像的更新模式,既支持覆盖又支持累加,所以数据源可以更新到DSO或者CUBE
AIE 采用后镜像模式,只支持覆盖,不支持累加,所以该类型数据源不能直接加载到CUBE,一般会先加载到DSO;在FI-AR/AP中此种增量处理方式应用较多
ADD 只支持累加,采用的是附加镜像的更新方式,所以既可以更新到DSO又可以更新到CUBE
There are various delta processes for SAP source systems (R/3, B2B, CRM...):
1. Creation of deltas with after, before and reverse images what are updated
directly to the delta queue. An after image provides the status after the
change, a before image the status before the change with a minus sign. A
reverse image sends the record with a minus sign too, indicating at the same
time that it is to be deleted. The data packages are serialized in the process.
The delta process controls whether adding or overwriting is allowed. In this
case, both adding and overwriting is allowed. This process permits data to be
updated in an ODS object as well as an InfoCube. (Technical name of the