DW_DMD_EXT_FUNC_AREA_TABLE_MAP

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

Details

Module:

Key Columns

TABLE_NAME, DATASOURCE_CODE, FUNCTIONAL_AREA_CODE

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.    

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