4.3.3.2 SYS_TBL_MASTER
The ALMBI Application Installer populates this table for the Seeded Dimensions.
Table 4-6 Seeded Dimensions
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. |
TBL_NM | VARCHAR2(30) NOT NULL | Dimension Table Name |
STG_TBL_NM | VARCHAR2(30) NOT NULLL | Staging Table Name |
SRC_PRTY | NUMBER(2) NULL | The priority of the Source when multiple sources are mapped to the same target. The sequence in which the various sources for the DIMENSION will be taken up for processing. |
SRC_TYP | VARCHAR2(30) NOT NULL | The type of the Source for a Dimension, that is, Transaction Or Master Source |
DT_OFFSET | NUMBER(2) NOT NULL | The offset for calculating the Start Date based on the FRD. |
SRC_KEY | NUMBER(3) NULL | Source Key |
Example: The following data is inserted by the Application Installer for the Product Dimension.
Table 4-7 Product Dimension
Column Name | Data Type |
---|---|
MAP_REF_NUM | NUMBER(3) NOT NULL |
TBL_NM | VARCHAR2(30) NOT NULL |
STG_TBL_NM | VARCHAR2(30) NOT NULL |
SRC_PRTY | NUMBER(2) |
No changes are required to this table if the Standard Key Dimensions are being used within ALMBI. If any new dimensions have been added (for example, ALM_COA_ID) a row will have to be inserted to this table manually.