loadname

Resolved as the load name in load execution.

See also:

• Variables

Usage

<loadname>

Notes

Supported in all loads.

Examples

Insert load name into target table with OVERRIDE

OVERRIDE load step in D_RATECODE entity in a load named load_d_ratecode_from_data_vault:

insert into <target_schema>.<target_entity_name>
select
    ... ,
    '<loadname>' as load_name, 
    ...
;

Load executed in the target database:

insert into publish.D_RATECODE
select
    ... ,
    'load_d_ratecode_from_data_vault' as load_name,
    ...
;

Use variable in entity mapping transformations

Note that variables can also be used in entity mapping without needing an OVERRIDE load step.

For example:

Generated SQL:

insert into publish.D_RATECODE
select
    ... ,
    'load_d_ratecode_from_data_vault' as load_name,
    ...
;

Furthermore, this could be defined as a transformation with CONFIG_LOAD_TRANSFORMATIONS and configured as default with CONFIG_ENTITY_DEFAULTS.