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	nvarchar(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.