Pattern check allows user to a regular expression for checking whether a specific values are exists in the given base table data.
Pattern check identifies if the base column data matching with a specified value.
Below are the possible Pattern conditions in uArrow,

  • For example:

If the Base Table is LINEITEM, Base Column is L_SHIPMODE, as per Pattern condtion check the values should match in the base column data.
Here, if the LINEITEM.L_SHIPMODE column value does not match with specified Pattern values, then those base table records are considered as invalid.

Steps to create Pattern check rule in uArrow:

1 Click + Add button in the Pattern check rule for column L_SHIPMODE.

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

* Column : Choose the Pattern column.
* Rule Description : Fill the description.
* Rule Category : Choose or create new dimension to classify rule if required.
* Pattern : Choose the Pattern operator.
* Pattern Value : Fill the Pattern values.
* Clink on Verify button and it will validate rule.
* Clink on save button

After providing all the details for pattern check.

Click verify and apply the pattern check rule, and then click save button to save job.