Jump to: navigation, search

CATEGORY Dimension

The CATEGORY dimension is populated from task information and contains a list of categories that further describe a task, such as a specific type of refund. This dimension is an extended iWD attribute that can be set by the source system.

The CATEGORY Dimension
Field Data Type Description
CATEGORY_KEY int Primary key of this table.
CATEGORY_NAME varchar(255) Descriptive name of the category.
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 19 August 2014, at 09:04.