Paired

Paired check is a functional check which will compare the values of two attributes for a given table.
uArrow support 3 types of pair checks

Implied

  • This check compare for the similar behavior of the paired columns meaning it check both columns either have data or not.

For example:
If the base table is LINEITEM, base column is L_SHIPDATE and reference columns is L_SHIPMODE with selected pair type “Implied” then the pair type check is defined as,

not ( (L_SHIPDATE is null and L_SHIPMODE is null) or (L_SHIPDATE is not null and L_SHIPMODE is not null)

Here, if the LINEITEM.L_SHIPDATE column value does not match with specified pair type check rule then those base table records are considered as invalid.

Steps to create Implied check rule in uArrow:

1 Click + Add button in the paired check rule for column L_SHIPDATE.

2 Do the following, In the paired section for rule.

* LHS Column : Choose the left hand side column.
* Rule Description : Fill the description.
* RHS Column : Choose the right hand side column.
* Pair Type : Choose paired check type.
* Clink on save button

Below is the window with values populated for pair check.

Mutually Exclusive

  • This check compare for the inverse relationship of the pair columns meaning if one column is null another column must not be null or vice versa

For example

If the base table is LINEITEM, LHS column is L_LINENUMBER and RHS columns is L_QUANTITY with selected pair type “Mutually Exclusive” then the pair type check is defined as,

not ( (L_SHIPDATE is not null and L_SHIPMODE is null) or (L_SHIPDATE is null and L_SHIPMODE is not null)

Here, if the L_LINENUMBER, L_QUANTITY column value does not match with specified pair type check rule then those base table records are considered as invalid.

To create paired Mutually Exclusive check rule in uArrow:

1 Click + Add button in the paired check rule for column L_LINENUMBER.

2 Do the following, In the paired section for rule.

* LHS Column : Choose the left hand side column.
* Rule Description : Fill the description.
* RHS Column : Choose the right hand side column.
* Pair Type : Choose paired check type.
* Clink on save button

Below is the window with all populated paired Mutually Exclusive check rules.

Value

  • This check compare the pair columns for a defined list of values.

For example
If the base table is LINEITEM, LHS column is L_LINESTATUS and RHS columns is L_RETURNFLAG with selected pair type “Value” then the pair type check is defined as,

 (L_LINESTATUS and  L_RETURNFLAG)  not match with (list of values uploaded)

Here, if the L_LINESTATUS,L_RETURNFLAG column value does not match with specified pair type check rule then those base table records are considered as invalid.

To create paired value check rule in uArrow:

1 Click + Add button in the paired check rule for column L_LINESTATUS.

2 Do the following, In the paired section for rule.

* LHS Column : Choose the left hand side column.
* Rule Description : Fill the description.
* RHS Column : Choose the right hand side column.
* Pair Type : Choose paired check type.
* Clink on upload button and select the paired value file.
* Clink on save button

Below is the window with all populated paired value check rules.

Note: Excel file column names should match with LHS and RHS column name defined in a Pair Value Check Rule.

Menu