OWB - Functional Dependency Rule

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

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

4 - Data Rule

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

Data Science
Data Analysis
Data Science
Linear Algebra Mathematics

Powered by ComboStrap