FSDF SCD-132 DIM_LOB Dimension Has FIC_MIS_DATE Filter Auto Applied
(Doc ID 2623999.1)
Last updated on AUGUST 21, 2020
Applies to:Oracle Financial Services Data Foundation - Version 8.0.7 to 8.0.8 [Release 8]
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.7 to 8.0.8 [Release 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Data Foundation (FSDF)
Slowly Changing Dimension (SCD)
On 8.0.7 version, data loaded via SCD 132 into DIM_LOB has filter auto-applied on FIC_MIS_DATE
During load of data into DIM_LOB dimension via SCD 132 (as taken from map_ref_num table), it was noticed that FIC_MIS_DATE filter is getting applied on the source view (DIM_LOB_V) and the number of loaded records is limited.
As seen in the out-of-the-box (OOTB) MERGE query generated as part of the processing, SCD has filter in the WHERE clause for the batch run extraction date.
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