Skip to main content
Skip table of contents

Load options

Load options can be used to make changes to automatically generated loads without needing to customize the entire load logic with an OVERRIDE or an OVERRIDE_FILE_LOAD load step. Some load options can even be used together with override load steps using variables that are placed into the code in the override step.

Please refer to the load option specific articles for further information:

Load option

Applicable load types

CUSTOM

Undocumented

OPT_DATA_FILE_LOCATION

LOAD_FILE

OPT_DELTA_EXTRACT

TRANSFORM_PERSIST

OPT_NUM_RUN_IDS_PER_TRANSACTION

TRANSFORM_PERSIST

OPT_FILE_FORMAT_OPTIONS

LOAD_FILE

OPT_LOAD_POOL

LOAD_FILE, TRANSFORM_PERSIST, TRANSFORM_SQL_VIEW

OPT_LOCK_WAIT_TIME_IN_SECS

LOAD_FILE, TRANSFORM_PERSIST, TRANSFORM_SQL_VIEW

OPT_NOT_EXISTS_FROM

TRANSFORM_PERSIST

OPT_NOT_EXISTS_WHERE

TRANSFORM_PERSIST

OPT_ORDER_BY

TRANSFORM_PERSIST, TRANSFORM_SQL_VIEW

OPT_SF_FILE_COPY_OPTIONS

LOAD_FILE

OPT_SKIP_DISTINCT_ONLY

TRANSFORM_PERSIST, TRANSFORM_SQL_VIEW

OPT_SKIP_DUPLICATE_PREVENTION

TRANSFORM_PERSIST, TRANSFORM_SQL_VIEW

OPT_STORAGE_INTEGRATION

LOAD_FILE

OPT_USE_RUN_IDS

TRANSFORM_PERSIST

OPT_USE_RUN_IDS_INCREMENTALLY

TRANSFORM_PERSIST

OPT_WHERE

TRANSFORM_PERSIST, TRANSFORM_SQL_VIEW

OPT_HISTORIZED_BY_DATAHASH_AS_INSERT

TRANSFORM_PERSIST

OPT_INSERT_UPDATE_BY_ID_AS_SWAP

TRANSFORM_PERSIST

OPT_INSERT_UPDATE_BY_DATAHASH_AS_SWAP

TRANSFORM_PERSIST

OPT_INSERT_UPDATE_DELETE_BY_ID_AS_SWAP

TRANSFORM_PERSIST

OPT_INSERT_UPDATE_DELETE_BY_DATAHASH_AS_SWAP

TRANSFORM_PERSIST

OPT_INSERT_UPDATE_BY_ID_AS_OVERWRITE

TRANSFORM_PERSIST

OPT_INSERT_UPDATE_BY_DATAHASH_AS_OVERWRITE

TRANSFORM_PERSIST

OPT_INSERT_UPDATE_DELETE_BY_ID_AS_OVERWRITE

TRANSFORM_PERSIST

OPT_INSERT_UPDATE_DELETE_BY_DATAHASH_AS_OVERWRITE

TRANSFORM_PERSIST

OPT_INSERT_UPDATE_BY_ID_AS_MERGE

TRANSFORM_PERSIST

OPT_INSERT_UPDATE_BY_DATAHASH_AS_MERGE

TRANSFORM_PERSIST

OPT_INSERT_UPDATE_DELETE_BY_ID_AS_MERGE

TRANSFORM_PERSIST

OPT_INSERT_UPDATE_DELETE_BY_DATAHASH_AS_MERGE

TRANSFORM_PERSIST

JavaScript errors detected

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

If this problem persists, please contact our support.