OWB - Data Auditor for Data Quality Monitoring

Card Puncher Data Processing

Definition

There are three places to measure and document data quality:

  1. Raw incoming data in the staging area
  2. After initial cleansing
  3. After final cleansing

Conditional Loading in a process flow

Data Auditor In Map You can design process flows that proceed based on the results of profiling data.

For example, the figure below displays a process flow that contains a Data Auditor Monitor activity. In this process flow, LOAD_EMP_MAP is a mapping that loads data into the EMP table. If the data load is successful, the data auditor EMP_DATA_AUDIT is run. The data auditor monitors the data in the EMP table based on the data rules defined for the table.

This decision point is something you should value. Rather than the above where you load bad data, now need to get it back out, you make an informed decision whether or not to load the data.

Reference





Discover More
Card Puncher Data Processing
OWB - How to start a job (Mapping, Process, ) from SQLPlus

A job for OWB is : a PL/SQL Mapping a SQLLoader Mapping a ProcessFlow a SAP Mapping a DataAuditor Mapping a Scheduled Job To start a job from SqlPlus, you must use : the script sqlplus_exec_template.sql...
Card Puncher Data Processing
Oracle Warehouse Builder

Owb Documentation - Understanding Data Quality Management White...



Share this page:
Follow us:
Task Runner