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.
|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.|
This page was last edited on December 19, 2017, at 10:26.