Questions on Using the 7.3 OFSAAI Data Quality (DQ) Framework (Doc ID 1546473.1)

Last updated on MARCH 13, 2017

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) - Version 7.3
Oracle Financial Services Analytical Applications (OFSAA) - Version 6.x

Goal

Questions about using the DQ 7.3 Framework:

Question 1: What are the tables used for the DQ Framework in the atomic and config schemas?

Question 2: What are the LOGS and XML files which get created using DQ?
 
Question 3: If the data in a stg table has some null values that need to be defaulted to 1 and sent to the processing table, can the DQ framework in OFSAAI 7.3.2 handle this?
 
Question 4: For DQ Referential checks, if a check is failed, is there a way to stop the following task from executing?  For example, if a batch is created with two or more tasks of load dat , transform data, DQ and Run execution.  If the DQ referential check is the third task in the batch, if it returns failed, will the 4th task of run execution still run?
 
Question 5: In terms of DQ duplicate checks, if there are any duplicates found in a STG table, does the DQ rule delete the duplicate entry (row)?
 
Question 6: In terms of the DQ column reference check, what can it do?

Question 7: Is the content of V_SRC_PK_COLS always the same for any given table?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms