OWB - Functional Dependency Rule

Card Puncher Data Processing

Definition

A functional dependency occur when :

The data of an attribute A (of a column) depend of a value of an other attribute B (of column) in the same table

Then we say that

  • The attribute A is the dependent
  • The attribute B is the determinant

A is then a derived attribute of B.

Functional Dependency tab

In the data profiling tools, the Functional Dependency tab shows any attribute(s) that seem to depend on or determine other attributes.

  • Determinant: The name of the attribute that is found to determine the attribute listed in the Dependent
  • Dependent: The name of the attribute found to be determined by value of another attribute
  • # Defects and % Compliance: These columns show the number of values that did not show the discovered dependency, and the percentage of values that did meet it.
  • Six Sigma: The six sigma value.
  • Type: The suggested action for the discovered dependency.

Data Rule

When you create a data rule with Project Explorer, OWB will ask you this two parameters.

Owb Functional Dependency





Discover More
Data Profiling Step
OWB - Data Profiling

If you don't know anything data profiling, you can have a look to the Data Profiling Page for a description. Nothing is better than a video : Most organizations build a data warehouse to provide an...
Global Explorer Public Data Rule
OWB - Data Rules

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...



Share this page:
Follow us:
Task Runner