Jump to: navigation, search

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.

Feedback

Comment on this article:

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