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 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 November 1, 2018, at 15:17.

Feedback

Comment on this article:

blog comments powered by Disqus