DW_DMD_EXT_FUNC_AREA_TABLE_MAP

Contains relationship between Functional Area and Warehouse tables for data enrichments.

Details

Module:

Key Columns

FUNCTIONAL_AREA_CODE, DATASOURCE_CODE, TABLE_NAME

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
DATASOURCE_CODE VARCHAR2 32 True Datasource code.
FUNCTIONAL_AREA_CODE VARCHAR2 256 True Functional area code
TABLE_NAME VARCHAR2 128 True Table name
TABLE_TYPE VARCHAR2 32 Table Type, FACT, DIMENSION, EXTENSION
FACTORY_TABLE_FLAG VARCHAR2 16 If the object is factory shipped or custom created, values can be Y or N
CLASS_CODE VARCHAR2 256 Represents the custom object generation source application.