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
| 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 |