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