DW_DMD_EXT_TABLE_JOIN_INFO

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

Details

Module:

Key Columns

RIGHT_TABLE, RIGHT_COLUMN, LEFT_COLUMN, DATASOURCE_CODE, LEFT_TABLE

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 This column is for Oracle Internal use only. 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.