Jump to: navigation, search

AGENT Dimension

The AGENT dimension, which is populated from task information, stores agent keys and IDs that are captured from the source system. This dimension is a core iWD attribute.

The AGENT Dimension
Field Data Type Description
AGENT_KEY int Primary key of this table.
AGENT_ID nvarchar(255) ID of the agent as captured by the source system.
CREATED_ETL_AUDIT_KEY int Key to the ETL_AUDIT dimension, identifying the ETL job that created this record.
UPDATED_ETL_AUDIT_KEY int Key to the ETL_AUDIT dimension, identifying the ETL job that last updated this record.

Feedback

Comment on this article:

blog comments powered by Disqus
This page was last modified on 19 December 2017, at 03:26.