DW_DMD_FUNC_AREA_TABLE_MAP
Contains relationship between Functional Area and Warehouse tables
Details
Module:
Key Columns
FUNCTIONAL_AREA_CODE, DATASOURCE_CODE, TABLE_NAME
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| DATASOURCE_CODE | VARCHAR2 | 32 | True | Source application code. | |||
| FUNCTIONAL_AREA_CODE | VARCHAR2 | 256 | True | Pillar code | |||
| TABLE_NAME | VARCHAR2 | 128 | True | Table name |