OWB - Data Rules

Card Puncher Data Processing

About

Data Rule is the key concept of the data quality. They are part of the Data Quality option to Warehouse Builder. If you don't know what is a data rule, please refer you to data rule.

For a complete explanation of how to implement and manage data rule see :

How to define your rule ?

Pre-build rule

You have already a lot of pre-build rule. You can see them in the global explorer as Public Data Rules.

Global Explorer Public Data Rule

Derive rule from a profiling result

You can also derive a data rule from a OWB - Data Profiling result. For instance below, we have discover a Domain List with the country column. Select it and create a data rule by clicking on the “Derive Data Rule”.

Owb Derive Data Rule

Data Rule in Project Explorer

You can define your own. You will find a data rule node in the project explorer. Just expand the node and right click on rule to launch a wizard.

Owb Own Data Rules

Create Data Rules in Scripting





Discover More
Owb Functional Dependency
OWB - Functional Dependency Rule

A functional dependency occur when : Then we say that The attribute A is the dependent The attribute B is the determinant A is then a derived attribute of B. In the data profiling tools, the...
Owb Table Operator With Err Table
OWB - How to implement and manage data rule in a mapping for a table ?

A data rule in OWB is a property of a table and you can manage its behaviour in the mapping. To implement data rule, you must : in the objects : define a then apply (of add) them to the table...
Owb Load Fact Mdm
OWB - How to load a fact table for a data quality cube ?

In one mapping, you can check all the data rules against a table and you can load the results in one fact table. On the check table STG_VENDOR_SAP4 (in the bottom left side), I have set the data rules...
Owb Table Operator Data Rule Properties
OWB - Table

The Table operator enables you to source data from and load data into tables stored You can set Target Filter for Update, Target Filter for Delete, and Match By Constraint. When a data...
Card Puncher Data Processing
Oracle Warehouse Builder

Owb Documentation - Understanding Data Quality Management White...
Owb Table Operator With Err Table
Owb - Error Handling (Error Logging Table and Data Rules)

Error logging enables the processing of DML statements to continue despite errors being encountered during the statement execution. DML error logging is supported for SQL statements such as INSERT, UPDATE,...
Owb Expression Builder
Owb Expression Builder

The allow you to compose expression. In the left side, you can choose your input and your transformation (procedure, function, ...) to compose in the right side you expression. The most known expression...



Share this page:
Follow us:
Task Runner