Provides the target entity attribute name for the desired attribute type
See also:
Usage
<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;