Questions Related to the Definition of the SCD for DIM_LOB
(Doc ID 2436890.1)
Last updated on MAY 07, 2023
Applies to:
Oracle Financial Services Data Foundation - Version 8.0.5 and laterOracle Financial Services Profitability Management - Version 8.0.5 and later
Oracle Financial Services Asset Liability Management - Version 8.0.5 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.6 to 8.0.6 [Release 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Goal
Qn1: In Oracle Financial Services Data Foundation (FSDF) 8.0.5, why are there 13 extra column entries present in SYS_STG_JOIN_MASTER for DIM_LOB (MAP_REF_NUM = 132)? The columns do not exist on DIM_LOB_V or on the target table DIM_LOB.
D_HEDGE_END_DATE
V_PROSP_EFF_MEASURE_METHOD
V_CREATED_BY
V_HEDGE_TYPE
V_INCEP_EFF_MEASURE_METHOD
V_RETRO_EFF_MEASURE_METHOD
V_LAST_MODIFIED_BY
D_LAST_MODIFIED_DATE
D_CREATED_DATE
V_HEDGE_NAME
N_HEDGE_SKEY
N_HEDGE_ID
D_HEDGE_START_DATE
Qn2: Why is there a mismatch is size between the columns DIM_LOB_V.V_LOB_NAME (VARCHAR2(150)) and DIM_LOB.V_LOB_NAME (VARCHAR2(20)) which can result in an error when trying to insert a name larger than 20 into DIM_LOB?
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |
| References |