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.

Feedback

Comment on this article:

blog comments powered by Disqus
This page was last modified on December 19, 2017, at 02:26.