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:
Usage
<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:
INSERT INTO <target_schema>.<target_entity_name>
SELECT ...
FROM <source_system_name>
results in:
INSERT INTO publish.D_RATECODE
SELECT ...
FROM SHARE_DATA