My Oracle Support Banner

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.

Goal

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
 

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.