The solution installer populates one row per dimension 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 is 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.
|
Field Name |
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. |