Jump to: navigation, search

CUSTOMER Dimension

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.

The CUSTOMER Dimension
Field Data Type Description
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 edited on December 19, 2017, at 10:26.
Comments or questions about this documentation? Contact us for support!