source_entity_attribute_by_{attribute_type}
Provides the source entity attribute name for the desired attribute type
See also:
Usage
VARIABLE
<source_entity_attribute_by_dv_load_time>
Notes
Supported in all loads.
Examples
Variable used in an OVERRIDE load step
Given mapping:
Target entity: publish.D_RATECODE
Source entity: src.SOURCE
source attributes | source attribute type | Formula | Target attribute |
---|---|---|---|
attribute_A,attribute_B,attribute_C | HASH | key_id | |
dv_load_time | DV_LOAD_TIME | ||
RUN_ID | run_id | ||
attribute_D | information |
OVERRIDE load step in D_RATECODE entity:
SQL
insert into <target_schema>.<target_entity_name>
select <source_entity_attribute_by_dv_load_time>
from <source_entity_schema>.<source_entity_name>;
Load executed:
SQL
insert into publish.D_RATECODE
select dv_load_time
from src.SOURCE;