Enhancement DGS 80901- "DGS DQ CTL Batch" - Task 4 - VW_DQ_RESULT_DETL_MASTER
(Doc ID 2734247.1)
Last updated on JUNE 23, 2021
Applies to:Oracle Financial Services Data Governance for US Regulatory Reporting - Version 8.0.8 and later
Information in this document applies to any platform.
Enhancement on DGS VW_DQ_RESULT_DETL_MASTER
Task 4 --> FN Refresh MatView (VW_DQ_RESULT_DETL_MASTER)
Based on Volume of Data in DQ_RESULT_DETL_MASTER ( more than 550 Million +) needs to be deleted/Truncated and then inserted in W_DQ_RESULT_DETL_MASTER
Below performance related issues are observed due to huge data volume:
1) Since Table volume is huge, FN Refresh MatView should refresh the view based on FIC_MIS_DATE & V_DATA_ORIGIN as well.
2) Impact of changing the "VW_DQ_RESULT_DETL_MASTER" with SOR Data only using V_SRC_PK_X column present
V_SRC_PK_X - Refers to the columns available in DQ_RESULT_DETL_MASTER
V_SRC_PK_1, V_SRC_PK_2, V_SRC_PK_3 etc
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