The solution installer will populate the SYS_STG_JOIN_MASTER table for the 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 Table. |
|
COL_NM |
VARCHAR2(30) NOT NULL |
Name of the column in the Dimension Table. |
|
COL_TYP |
VARCHAR2(30) NOT NULL |
Type of column. The possible values are given in the following paragraph. |
|
STG_COL_NM |
VARCHAR2(60) NULL |
Name of the column in the Staging Table. |
|
SCD_TYP_ID |
NUMBER(3) NULL |
SCD type for the column. |
|
PRTY_LOOKUP_ REQD_FLG |
CHAR(1) NULL |
Column to determine whether Lookup is required for Priority of Source against the Source Key Column or not. |
|
COL_DATATYPE |
VARCHAR2(15) NULL |
The list of possible values are VARCHAR, DATE, NUMBER based on the underlying column datatype. |
|
COL_FORMAT |
VARCHAR2(15) NULL |
Column format. |
The possible values for column type (the COL_TYPE column) in SYS_STG_JOIN_MASTER are:
|
Column Type |
Description |
|
PK |
Primary Dimension Value (can be multiple for a given "Mapping Reference Number") |
|
SK |
Surrogate Key |
|
DA |
Dimensional Attribute (can be multiple for a given "Mapping Reference Number") |
|
SD |
Start Date |
|
ED |
End Date |
|
LRI |
Latest Record Indicator (Current Flag) |
|
CSK |
Current Surrogate Key |
|
PSK |
Previous Surrogate Key 9.SS Source Key |
|
LUD |
Last Updated Date / Time |
|
LUB |
Last Updated By |
Sample Data:
This is the row put in by the solution installer for the Line of Business dimension.
|
Item |
Description |
|
MAP_REF_NUM |
6 |
|
COL_NM |
V_LOB_CODE |
|
COL_TYP |
PK |
|
STG_COL_NM |
V_LOB_CODE |
|
SCD_TYP_ID |
|
|
PRTY_LOOKUP_REQD_FLG |
N |
|
COL_DATATYPE |
VARCHAR |
|
COL_FORMAT |
61 |
|
NOTE |
For any new dimension added, the column details will have to be inserted to this table manually. |