Skip to main content
Delphix

Rule Set Feature: Add Column (KBA4457)

 

KBA

KBA# 4457

At a Glance   

Versions: Applicable Delphix Masking versions: 4.x, 5.0.x, 5.1.x, 5.2.x, 5.3.x
Description: Applicable to On-The-Fly masking only. This feature is used to manage memory usage and performance. 

Use this function to select/deselect column(s) from a table when you don't want to load those columns through the masking job. These value will not be inserted into the target.
Location: UI: Rule Set > Edit Table Settings > Add Column
API: [not available]
RS Indicator: Table Indicator in the Rule Set: 'COL'.

Usage   

This feature is only applicable to On-The-Fly masking and only on tables with many columns with a large amount of data. 

Since loading unmasked data into On-The-Fly will require memory and also affects the performance this feature is used to manage these two aspects. 

The best way to use the feature is to select all columns first and deselect the columns that should not be passed through. There is no error if a column is selected that is needed for masking. 

 

important

Important:

  • All Masked and ID Columns need to be selected or the masking job will throw an error (due to missing columns).
  • The values in the deselected columns will be set to NULL.

 

UI Examples  

In the examples below have the following names been used: 

  • Rule Set: 'Rule Set Features RS'
  • Original Tabe Name: 'Main_Table'

Rule Set page  

Please note the 'COL' indicator when the table has Add Column defined. 


UI RS - COL.png

Edit Table Settings popup  

This shows an example using Add Column. The column 'NotMasked' will be passed through and set to NULL on the target. 

UI - RS Feature - Add Column.png

Missing input error  

If no column is select then this error is shown. 

UI - RS Feature - Add Column Error.png

Related Articles  

The following product documentation may provide more information or related information to this article: