Relation

Relation check is to compares the base column data with another column of the base table .It will check all base column data with another selected column data.

Below are the possible relation conditions,

For example:

If the base table is LINEITEM, base table left hand side(LHS) column is L_DISCOUNT and base table right hand side(RHS) columns is L_EXTENDEDPRICE with relation condition is “<” then the relation check is defined as,

(not exists (select L_DISCOUNT from LINEITEM where L_DISCOUNT < L_EXTENDEDPRICE)).

Here, if the LINEITEM.L_DISCOUNT column value does not match with specified relation check then those base table records are considered as invalid.

Steps to create relation check rule in uArrow:

1 Click + Add button in the relation check rule for column L_DISCOUNT.

2 Do the following, In the relation section for rule.
* LHS Column : Choose the left hand side column.
* Rule Description : Fill the description.
* RHS Column : Choose the right hand side column.
* Relation : Choose relation check condition.
* Clink on save button

Below is the window with values populated for relation check.

Menu