When you create a plan, add data subset and data masking components. To perform the data subset operation, add the CUSTOMER_DATA_ENTITY entity that you created. To perform the data masking operation, add the Cust_CreditCard masking rule that you created.
In the project, click
Execute
.
Click
Actions
New
.
In the
New Plan
dialog box, enter the name Cust_Details_Plan and optional description for the plan.
Click
Next
.
To add a data masking operation to the plan, click
Add Masking Components
.
Select the Cust_CreditCard masking rule to add to the plan. Click
Next
.
To add a data subset operation to the plan, click
Add Subset Components
.
Select the CUSTOMER_DATA_ENTITY entity to add to the plan. Click
Next
.
To skip adding a data generation component, click
Next
.
Review the masking and subset components.
Click
Next
.
In the
Source Connection
field, select
Relational
. Click
Select
and choose the TDM_Source1 database connection that you created.
In the Target Connection field, select
Relational
. Click
Select
and choose the TDM_Target1 database connection that you created.
Configure the following target settings:
Truncate Tables
To truncate the table before the data loads, select
Truncate Tables
.
Disable Indexes
To disable indexes for faster loading of data, select
Disable Indexes
.
Disable Constraints
To disable physical constraints before the data is loaded to the target database, select
Disable Constraints
. After the data loads, the constraints are enabled automatically.
Configure the following update strategy options:
Treat Source Rows As
To insert the source rows, select
Insert
.
Update As
To update all the flagged rows that are marked for update, select
Update
.
The following image shows sample plan settings that you can configure:
Click
Next
.
Review the plan, tables, and data source settings.