DW_TARGET_EXTENSION_MAPPINGS_DFG

Stores information about the extended DFF Attributes. This table Contains all the Extended DFF tables and its corresponding attributes and labels.

Details

Module:

Key Columns

DW_TABLE_NAME, DW_COLUMN_NAME, DATASOURCE_CODE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
DATASOURCE_CODE VARCHAR2 32   True Datasource code.    
DW_TABLE_NAME VARCHAR2 128   True DFF Target table name    
DW_COLUMN_NAME VARCHAR2 128   True DFF Attribute Name    
DW_DATA_TYPE VARCHAR2 32     DFF Data Type    
DW_DATA_LENGTH VARCHAR2 16     DFF Data Length    
DW_DATA_SCALE VARCHAR2 16     DFF Data scale    
DW_IS_PRIMARY VARCHAR2 16     DFF IS Primary Column    
DISPLAY_LABEL VARCHAR2 999     DFF Prompt Value    
COLUMN_ORDER VARCHAR2 16     DFF column position    
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.    
IS_HIDDEN VARCHAR2 16     If column need to be hidden.    

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