DW_ENRICHMENT_TABLE_DETAILS

Stores information of the latest job that updated the DFF table

Details

Module:

Key Columns

DATASOURCE_CODE, ENRICHMENT_TABLE_NAME

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
DATASOURCE_CODE VARCHAR2 32 True Datasource code.
ENRICHMENT_TABLE_NAME VARCHAR2 128 True DFF Target table name
CREATED_BY_JOB VARCHAR2 32 Job ID that created mapping
SOURCE_TYPE_CODE VARCHAR2 64 Source type code for example fusion or netsuite
TABLE_TYPE VARCHAR2 32 Table type either DFF or DE
FUNCTIONAL_AREA_CODE VARCHAR2 256 Functional area code
CLASS_CODE VARCHAR2 256 Represents the custom object generation source application.