Tasks are typically associated with a customer. The CUSTOMER dimension holds the unique identifier—either customer ID or account ID—and is populated from task information. This dimension is an extended iWD attribute.
|CUSTOMER_KEY||int||Primary key of this table.|
|CUSTOMER_ID||nvarchar(64)||Unique ID assigned to the customer, provided 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 modified on December 19, 2017, at 03:26.