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.
|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.|
This page was last edited on December 19, 2017, at 10:26.