Contains info on join conditions between fact and dimension of enrichment tables
Module:
RIGHT_COLUMN, LEFT_COLUMN, LEFT_TABLE, DATASOURCE_CODE, RIGHT_TABLE
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.