OPT_DELTA_EXTRACT

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.

See also:

• Load options

Usage

OPT_DELTA_EXTRACT: Boolean

Default: true

Notes

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.

Examples

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:

OPT_DELTA_EXTRACT: true

Respectively, with full data extracts use:

OPT_DELTA_EXTRACT: false