target_entity_attribute_by_{attribute_type}
Provides the target entity attribute name for the desired attribute type
See also:
Usage
VARIABLE
<target_entity_attribute_by_dv_hashkey>
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 | Formula | Target attribute |
---|---|---|
attribute_A,attribute_B,attribute_C | HASH | key_id |
RUN_ID | run_id | |
attribute_D | information |
OVERRIDE load step in D_RATECODE entity:
SQL
insert into <target_schema>.<target_entity_name>
select <target_entity_attribute_by_dv_hashkey>
from <source_entity_schema>.<source_entity_name>;
Load executed:
SQL
insert into publish.D_RATECODE
select key_id
from src.SOURCE;