DW_DMD_TABLE_DOMAINS

Contains Warehouse Table Key To Domain Key Relationship

Details

Module:

Key Columns

DATASOURCE_CODE, TABLE_NAME, DOMAIN_KEY, DOMAIN_CODE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
DATASOURCE_CODE VARCHAR2 32 True Source application code.
TABLE_NAME VARCHAR2 128 True Table name
DOMAIN_CODE VARCHAR2 128 True Domain Code
DOMAIN_KEY VARCHAR2 128 True Domain key
SOURCE_RECORD_ID VARCHAR2 512 This column is for Oracle Internal use only. Source record identifier.
DOMAIN_KEY_COLUMN VARCHAR2 128 Domain key column of table corresponding to actual domain Key