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

DATASOURCE_CODE, DW_COLUMN_NAME, DW_TABLE_NAME

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
FOLDER VARCHAR2 128 DFF column folder
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.