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.
| Field | Data Type | Description |
|---|---|---|
| CUSTOMER_KEY | int | Primary key of this table. |
| CUSTOMER_ID | varchar(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 August 19, 2014, at 16:04.
Comments or questions about this documentation? Contact us for support!