SOURCE_PROCESS Dimension

Tasks may be associated with a larger process—say, in a workflow system. As an extended attribute, the SOURCE_PROCESS dimension includes a process type and subtype and can be set by the source system.

The SOURCE_PROCESS Dimension

Field	Data Type	Description
SOURCE_PROCESS_KEY	int	Primary key of this table.
SOURCE_PROCESS_TYPE	nvarchar(64)	Name of the source-system process—for example, Order.
SOURCE_PROCESS_SUBTYPE	nvarchar(64)	Subtype of the process—for example, Activation.
CREATED_ETL_AUDIT_KEY	int	Key to ETL_AUDIT, identifying the ETL job that created this record.
UPDATED_ETL_AUDIT_KEY	int	Key to ETL_AUDIT, identifying the ETL job that last updated this record.