source_entity_name_{N}

Resolved as the Nth source entity name in load execution.

See also:

• source_entity_schema

• target_entity_name

• target_schema

• Variables

• Entities

Usage

<source_entity_name_2>

Notes

Supported in all loads.

Works with multiple entity mappings, source_entity_schema_{N} and source_entity_name_{N}, where N refer to the entity mapping position. Also see entity mapping types.

Examples

Variable used in an OVERRIDE load step

OVERRIDE load step in a load with an entity mapping with source entity staging.STG_ADVENTUREWORKS_DEPARTMENT and
reference.DATA_LOOKUP:

select
  ...
from <source_entity_schema>.<source_entity_name> a
join <source_entity_schema_2>.<source_entity_name_2> b on (a.id = b.id)

Load executed in the target database:

select
  ...
from staging.STG_ADVENTUREWORKS_DEPARTMENT a
join reference.DATA_LOOKUP b on (a.id = b.id)