SAP Knowledge Base Article - Public

3783490 - Datasphere - Delta Load in a Replication Flow works even when Delta Capture is switched off on the target table in SAP Datasphere

Symptom

  • You have created a Replication Flow in SAP Datasphere using the Initial and Delta load type.
  • The Delta Capture setting on the target local table is switched off.
  • Despite this, the delta load of the replication runs normally and replicates changes as expected.

Environment

SAP Datasphere

Cause

This behavior is expected. It is possible for the delta load to work even if Delta Capture is not enabled on the target local table. The Delta Capture setting on the target table is not a prerequisite for using the Initial and Delta load type. It only controls whether changes to the target local table itself are recorded for further delta processing.

Resolution

Local table as target

For the Initial and Delta load type, SAP recommends using a target local table with Delta Capture enabled, but it is not mandatory. The Initial and Delta load of the Replication Flow will run correctly regardless of the Delta Capture setting on the target table. See Local Table as Target | SAP Help Portal.

Local table as source

If you plan to use a local table as the source object, the Delta Capture setting is mandatory. See the last point in the 'Initial and Delta' note: Creating a Replication Flow – Procedure | SAP Help Portal

Local tableDelta Capture requirement (for Initial and Delta)
TargetRecommended, but not mandatory
SourceMandatory

See Also

Keywords

Datasphere, Replication Flow, Delta Capture, Initial and Delta, delta load, target local table, source local table , KBA , DS-DI-RF , Replication Flow Runtime , Problem

Product

SAP Datasphere 1.0