DW_DMD_EXT_TABLES

Contains data enrichment table information

Details

Module:

Key Columns

DATASOURCE_CODE, TABLE_NAME

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
DATASOURCE_CODE VARCHAR2 32   True Datasource code.    
TABLE_NAME VARCHAR2 128   True Table name    
SOURCE_RECORD_ID VARCHAR2 256     Source record identifier.    
TABLE_DESCRIPTION VARCHAR2 1024     Table description    
TABLE_TYPE VARCHAR2 64     Table type    
TABLE_ROLE VARCHAR2 64     Table role    
AUGMENTATION_NAME VARCHAR2 512     Table augmentation name    
ENRICHMENT_ACTION_TYPE VARCHAR2 128     Enrichment action type    
ENRICHMENT_OBJECT_TYPE VARCHAR2 128     Enrichment object type    
ENRICHMENT_OBJECT_SOURCE VARCHAR2 128     Enrichment object source    
EXTENDED_DOMAIN VARCHAR2 128     Extending Domain