5.4.1.4 Create Nullify Policy

This section provides the details on nullifying the column from selected tables based on user defined criteria.

To create Nullify Policy, follow these steps:

1. Navigate to New Policy page.
2. Follow the steps mentioned in below sections:
   1. Step 1: Policy Definition
   2. Step 2: Choose Columns
   3. Step 3: Condition
   4. Step 4: Preview and Submit

Step 1: Policy Definition section

1. From Policy Details tab, click Start. The Policy Definition page is displayed.

   Figure 5-39 Policy Definition section

   
   

   

   
   
2. Enter the following details:
   • Name: Name of Policy
   • Description: Description of Policy
   • Table Group: If this option is selected as No, then you can select Policy Type as Drop Partition.
   • Type: Type of Policy as Nullify
   • Policy Execution Date: Select the execution date and time of policy using calendar

Step 2: Choose Columns section

1. Navigate to the Choose Columns section.

   Figure 5-40 Choose Columns

   
   

   

   
   
2. To select the columns which you want to nullify, click

   Figure 5-41 Search Columns

   
   

   

   
   
   in Select Columns field. The Search window is displayed.

   Figure 5-42 Search Columns

   
   

   

   
   
3. Select columns and click Add.
4. Click Continue.

Step 3: Conditions

This section allows you to define the conditions(s) to archive the table.

1. Navigate to the Conditions section.

   Figure 5-43 Conditions section

   
   

   

   
   
2. Select the column(s) using Filter Column.
3. Select operator from Clause Name drop-down. The list of operators displays based on the selected Column Name.

   Note:

   You must select at least one condition to avoid the full table archive. Use AND if you want to use multiple columns. You can select columns from pre-defined list. Don’t use wild card characters. Supported operators are: >, <, <=, and =>.

4. Enter condition value for selected column.

   For example, If you have selected Column as Account Number, then select Equals operator from Clause Name drop-down, and enter alphanumeric value in Value field.

   Click Row Actions icon to view single row, add a new row, create duplicate row, delete row, refresh row, or revert changes.

   To add more conditions, define the condition and click Save.

5. Click Continue.

Step 4: Preview and Submit section

1. Navigate to Preview and Submit section. Review the policy details.

   Figure 5-44 Preview and Submit section

   
   

   

   
   
2. Click Submit to create the policy. The created policy will be displayed on Data Housekeeping Summary page.

   Note:

   Data that is archived remains in the same table but is invisible to user. Thus, they cannot be inserted back as it will violate unique constraint of concerned table.