MODIFY_LOADER

Modify specified DBI-Loader record.

Table: DBIADM.DBI_LOADER (Generic DBI loader definitions)

Parameter Name

Properties

Default Value

Parameter Description

p_ldr_name

(PK)(NN)

Name of the loader process for a specific data table.

p_src_schema

(NN)

Schema name on the source system of the object to be loaded

p_src_table

(NN)

Object name on the source system

p_cdc_group

(NN)

Name of the change data capture group as defined in DBI_CDCG_GROUP.CDC_GROUP (foreign key)

p_cdc_type

(NN)

extraction/load method: INCR (incremental), FULL (full load), CT (change tracking) or INFU (incremental-full)

p_src_split_expr

column expression that is used for splitting parallel loads - must return an integer

p_tsa_retention

(NN)

10

Number of days until data will be removed from TSA tables

p_src_incr_expr

SQL expression that is used for incremental loads (column CDC_TYPE INCR or INFU) to detect changed records. The return value must be integer, date or timestamp. For incremental loads this column is mandatory.

p_use_ultimo_shift

(NN)

FALSE

Should ultimo shift be used? Ultimo shift: if calendar ultimo <> business ultimo –> BDATE will be shifted to calendar ultimo. Possible values: true or false.

p_src_incr_datatype

Data type of value that is returned by SRC_INCR_EXPR (‘I’ for integer, ‘T’ for timestamp, ‘D’ for date) - mandatory for incremental CDC_TYPE

p_autofill_missing_days

(NN)

FALSE

Automatically create TSA_CONTROL entries for days that are missing (based on load cycles) and cannot be delivered anymore

p_incr_offset

Offset for incremental load in days for SRC_INCR_DATATYPE = D/T, integer for SRC_INCR_DATATYPE = I - extraction fetches overlapping rows from source

Example

EXECUTE SCRIPT api_dbiadm.modify_loader
            ( 'XXX'      -- p_ldr_name
            , 'XXX'      -- p_src_schema
            , 'XXX'      -- p_src_table
            , 'XXX'      -- p_cdc_group
            , 'XXX'      -- p_cdc_type
            , 'XXX'      -- p_src_split_expr
            , 10         -- p_tsa_retention
            , 'XXX'      -- p_src_incr_expr
            , FALSE      -- p_use_ultimo_shift
            , 'XXX'      -- p_src_incr_datatype
            , FALSE      -- p_autofill_missing_days
            , 0          -- p_incr_offset
            );