OPT_DELTA_EXTRACT is a load option for automatically generated status satellite loads to set whether the source table load is based on a delta extract or a full extract.
OPT_DELTA_EXTRACT can be used with status satellite loads that have a single entity mapping (i.e. one source entity) and no OVERRIDE load steps. OPT_DELTA_EXTRACT will not have an effect if the load is overridden with an OVERRIDE load step.
Using OPT_DELTA_EXTRACT in a status satellite load
If a status satellite is loaded from an incremental data extract, i.e. batches loaded to the source staging table do not contain a full extract of the source data, use:
Respectively, with full data extracts use: