DW_DMD_EXT_TABLE_JOIN_INFO

Contains info on join conditions between fact and dimension of enrichment tables

Details

Module:

Key Columns

LEFT_COLUMN, RIGHT_COLUMN, LEFT_TABLE, RIGHT_TABLE, DATASOURCE_CODE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
DATASOURCE_CODE VARCHAR2 32   True Datasource code.    
LEFT_TABLE VARCHAR2 128   True Left side table of join condition    
RIGHT_TABLE VARCHAR2 128   True Right side table of join condition    
LEFT_COLUMN VARCHAR2 128   True Left table join column    
RIGHT_COLUMN VARCHAR2 128   True Right table join column    
SOURCE_RECORD_ID VARCHAR2 512     Source record identifier.    
SOURCE_DATASOURCE_CODE VARCHAR2 128     Datasource code for the source object used in the join condition.    
SOURCE_ENTITY_TYPE VARCHAR2 128     Entity type for the source object used in the join condition, Possible values are System and Enrichment.    
SOURCE_DOMAIN_CODE VARCHAR2 128     Domain of table joinging to the data enrichment custom table.    
FUNCTIONAL_AREA_CODE VARCHAR2 256     Functional area code    
CLASS_CODE VARCHAR2 256     Represents the custom object generation source application.    

Copyright © 2019, 2023, Oracle and/or its affiliates.