Skip to main content
Skip table of contents

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:


Usage

OPTION
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:

OPTION
OPT_DELTA_EXTRACT: true

Respectively, with full data extracts use:

OPTION
OPT_DELTA_EXTRACT: false
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.