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.
| Field | Data Type | Description |
|---|---|---|
| SOURCE_PROCESS_KEY | int | Primary key of this table. |
| SOURCE_PROCESS_TYPE | varchar(64) | Name of the source-system process—for example, Order. |
| SOURCE_PROCESS_SUBTYPE | varchar(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 October 30, 2018, at 12:03.
Comments or questions about this documentation? Contact us for support!