DW_ENRICHMENT_TABLE_DETAILS

Stores information of the latest job that updated the DFF table

Details

Module:

Key Columns

ENRICHMENT_TABLE_NAME, DATASOURCE_CODE

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.    

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