Rule Set Feature: Join Table (KBA4459)

At a Glance

Versions:	Applicable Delphix Masking versions: 4.x, 5.0.x, 5.1.x, 5.2.x, 5.3.x
Description:	Use this feature to specify a SQL join to select specific data based on values in a second (or third...) table.
Location:	UI: Rule Set > Edit Table Settings > Join Table API: [not available]
RS Indicator:	Table Indicator in the Rule Set: 'JC'.
Version Updates:	-

Usage

Use this feature to join the masked table with another table(s) and using this join to filter the data.

To use the feature, create a Rule Set with the table being masked (Main_Table) and the table(s) used in the join.

Main_Table - the table masked.
Join_Table(s) - the tables used in the join.

Then in the Join Table feature, define these components (the numbers correspond with the numbers in the SQL example below):

The Source Column (field: 'Select Value').
The Join Table (field: 'Select Table').
The Join Column (field: 'Select Column').

The final SQL looks something like this:

select 
   Main_Table.ID,
   Main_Table.Key,                         < 1.
   Main_Table.Mask 
from 
   Main_Table,
   Join_Table                              < 2.
where 
   Main_Table.Key = Join_Table.Join_Key    < 3.

UI Examples

In the examples below the following names have been used:

Rule Set: 'Rule Set Features RS'.
Original table Name: 'Main_Table'.
Join table name: 'Join_Table'.

Rule Set page

Please note the 'JC' indicator on the Main_Table and the Rule Set has to have the Join Table defined.

UI - RS Feature - Join Table - RS Edit.png

Edit Table Settings popup

This shows an example of joining Main_Table with Join_Table using column Key joined with column Join_Key. The SQL generated for this join is shown above.

UI - RS Feature - Join Table - Feature Edit.png

Missing input error

There are two errors possible when configuring this feature:

Missing input
- "Please select the source column."
- "Please select the target table."

The example below shows "Please select the target table."

UI - RS Feature - Join Table - Missing Input.png

KBA