Jump to: navigation, search

SOURCE_TENANT Dimension

In cases in which the source system is part of a multi-tenant system, the source_process and source_product values might not be unique across tenants. The SOURCE_TENANT dimension provides the ability to define the source of the task further. As an extended attribute, SOURCE_TENANT can be populated by the source system that is submitting the task.

The SOURCE_TENANT Dimension
Field Data Type Description
SOURCE_TENANT_KEY int Primary key of this table.
SOURCE_TENANT_NAME nvarchar(64) Name of the tenant from the source system.
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.

Feedback

Comment on this article:

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