5.5.1 SYS_TBL_MASTER
The solution installer will populate one row per dimension for the seeded dimensions in this table. SYS_TBL_MASTER:
Table 5-4 Rows populated for the seeded dimensions in the SYS_TBL_MASTER table
| Column Name | Data Type | Column Description |
|---|---|---|
| MAP_REF_NUM | NUMBER(3) NOT NULL | The Mapping Reference Number for this unique mapping of a Source to a Dimension Table. |
| TBL_NM | VARCHAR2(30) NOT NULL | Dimension Table Name |
| STG_TBL_NM | VARCHAR2(30) NOT NULL | Staging Table Name |
| SRC_PRTY | SRC_PRTY NUMBER(2) NULL | Priority of the Source when multiple sources are mapped to the same target. |
| SRC_PROC_SEQ | NUMBER(2) NOT NULL | The sequence in which the various sources for the DIMENSION will be taken up for processing. |
| SRC_TYP | VARCHAR2(30) NULL | The type of the Source for a Dimension, that is, Transaction Or Master Source. |
| DT_OFFSET | NUMBER(2) NULL | The offset for calculating the Start Date based on the Functional Requirements Document (FRD). |
| SRC_KEY | NUMBER(3) NULL |
Sample Data: This is the row put in by the solution installer for the Line of Business dimension.
Table 5-5 Sample data in the rows populated for the Line of Business dimension in the SYS_TBL_MASTER table
| Parameter | Value |
|---|---|
| MAP_REF_NUM | 6 |
| TBL_NM | DIM_LOB |
| STG_TBL_NM | STG_LOB_MASTER |
| SRC_PRTY | |
| SRC_PROC_SEQ | 23 |
| SRC_TYP | MASTER |
| DT_OFFSET | 0 |
| SRC_KEY |
Note:
For any new dimension added, a row will have to be inserted to this table manually.