Data Masking Transformation Configuration
Use the following steps to configure a Data Masking transformation.
- 1. Configure execution options for the Data Integration Service.
- 2. Create the transformation.
- 3. Define the input ports.
- 4. Configure masking rules for each port that you want to change.
- 5. Preview the data to verify the results.
Configure the Data Integration Service
You can configure execution options for the Data Integration Service in Informatica Administrator (the Administrator tool).
Configure execution options to set the following default directories:
- •Home directory. Contains the source directory and the cache directory.
- •Source directory. Contains source files for workflows. For example, the source directory can contain the highgrp.txt and defaultvalue.xml files.
- •Cache directory. Contains cache files for substitution masking.
To set values for the execution options, open the Administrator tool, and select the Data Integration Service in the Domain Navigator. Click the Properties view, and then click Edit in the Execution Options section.
Defining the Ports
Add Data Masking input ports on the Overview view. When you create an input port, the Developer tool creates a corresponding output port by default. The output port has the same name as the input port.
1. On the Overview view, click New to add a port.
2. Configure the datatype, precision, and scale for the column.
You must configure the column datatype before you define masking rules for the column.
3. To configure data masking for the port, click the arrow in the masking type column of the Overview view.
Configuring Data Masking for Each Port
Select a masking technique and the corresponding masking rules for a port on the Data Masking dialog box. The Data Masking dialog box appears when you click the data masking column on the Ports tab.
1. Enable Apply Masking in order to configure masking for the selected port.
The Developer tool displays a list of masking techniques that you can use based on the datatype of the port you are masking.
2. Select a masking technique from the list.
The Developer tool displays different masking rules based on the masking technique that you choose. Some of the special mask formats have no masking rules to configure.
3. Configure the masking rules.
4. Click OK to apply the data masking configuration for the port.
When you define data masking for a port, the Developer tool creates an output port called out-<port name>. The <port name> is the same name as the input port. The Data Masking transformation returns the masked data in the out-<port name> port.
Previewing the Masked Data
You can compare the masked data to the original data when you view the Data Masking transformation results in the Data Viewer.
1. After you configure the Data Masking transformation ports and masking rules, create a mapping that includes the physical data object source and the Data Masking transformation.
2. Connect the source to the Data Masking transformation.
3. Verify that the source has data in a shared location that the Data Integration Service can access.
4. Click the Data Masking transformation to select it in the mapping.
5. Click Data Viewer and click Run.
The Developer tool displays data for all the Data Masking transformation output ports. The ports that have the output prefix contain the masked data. You can compare the masked data to the original data in the Data Viewer view.