5.2.2.2 Setup Table Configuration Mapping

The FSI_DIM_LOADER_SETUP_DETAILS stores the STG_<DIM>_MASTER table details as follows:

Table 5-4 FSI_DIM_LOADER_SETUP_DETAILS

FSI_DIM_LOADER_SETUP_DETAILS	STG_<DIM>_MASTER
N_DIMENSION_ID	<dimension_id> For example, 617
V_INTF_B_TABLE_NAME	Stage table name
	For example, STG_ACCOUNT_OFFICER_MASTER
V_GEN_SKEY_FLAG	Default will be 'Y', it generates Surrogate Key.
	When 'N' then stage display code column will be used as a surrogate key.
	For example, FSI_ACCOUNT_OFFICER_CD.ACCOUNT_OFFICER_DISPLAY_CD should be numeric.
V_STG_MEMBER_COLUMN	Stores the stage display code column.
	For example, STG_ACCOUNT_OFFICER_MASTER.v_acct_officer_display_code
V_STG_MEMBER_NAME_COL	Stores the stage column name.
	For example, STG_ACCOUNT_OFFICER_MASTER. v_Name
V_STG_MEMBER_DESC_COL	Stores the stage description column name.
	For example, STG_ACCOUNT_OFFICER_MASTER. v_description