source_system_name

Resolved as the system name in case either TARGET entity or SOURCE entity is of entity type SOURCE.
TARGET entity will take preference, in case both are of entity type SOURCE.

See also:

Variables

Usage

CODE

<source_system_name>

Notes

Supported in all loads.

Examples

Target entity publish.D_RATECODE

Source entity (entity type SOURCE) src.SHARE_DATA_LINK, having source system set as SHARE_DATA.

Template:

CODE

INSERT INTO <target_schema>.<target_entity_name>
SELECT ...
FROM <source_system_name>

results in:

CODE

INSERT INTO publish.D_RATECODE
SELECT ...
FROM SHARE_DATA