Technical attribute types are system attribute types that can have features and load automation patterns related to them. Entity type defines which technical attribute types are available.
See also:
|
Technical attribute type |
Entity type |
Description |
|---|---|---|
|
DV_DATAHASH |
SAT |
SAT attributes are concatenated and hashed into the DV_DATAHASH attribute which is used in SAT loads to compare incoming data to existing data. |
|
DV_DRIVING_KEY |
S_SAT |
Business key that drives a LINK, i.e. the business key over which changes in other business keys of a LINK are recorded in a S_SAT. |
|
DV_HASHKEY |
HUB, LINK |
Hashed business key, primary key in HUB. Concatenated hashed business keys, primary key in LINK. |
|
DV_LOAD_TIME |
GENERIC, HUB, LINK, SAT, S_SAT |
Load timestamp |
|
DV_REFERENCING_HASHKEY |
SAT, S_SAT |
Hashed business key, foreign key reference to HUB DV_HASHKEY. |
|
RUN_ID |
STAGE, GENERIC, HUB, LINK, SAT, S_SAT |
Source-target entity specific incrementing unique integer load id for Run ID Logic. Also see OPT_USE_RUN_IDS. |
|
DV_SOURCESYSTEM |
GENERIC, HUB, LINK, SAT, S_SAT |
Source system name recorded to DV_SOURCE attribute. |
|
SDT_SORT_ORDER |
STAGE |
An index number for sorting source data. |
|
SDT_STAGE_CREATE_TIME |
STAGE |
Source metadata, batch timestamp. |
|
SDT_STAGE_ID |
STAGE |
Legacy option |
|
SDT_STAGE_SOURCE |
STAGE |
Source system name |
|
SDT_STAGE_SOURCE_TECH |
STAGE |
Legacy option |
|
SDT_STAGE_SOURCE_TYPE |
STAGE |
Legacy option |
|
STATUS |
S_SAT |
Status attribute in S_SAT. Records the status (1 or 0) of a LINK relationship at a given point in time. |
|
TIMESLOT |
* |
Timestamp field which can be used for helping the event data loading by limiting the NOT_EXISTS_WHERE- query to be limited to a certain time range instead of the whole target table |