TECHNICAL ATTRIBUTE TYPE
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 |