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

Last updated on JUNE 21, 2021

Applies to:

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

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