You can use the privacy policy editor to create a hash
lookup policy in a data access plan.
You can add a policy
to a data access plan that includes a selection policy.
Before
you can create a hash lookup policy, you must define a lookup data
source for the target platform selected for the policy.
To create a hash lookup policy:
- Expand a Data
Access Plans folder for a logical data model package in
the Data Project Explorer.
- Double-click
the data access plan to include the policy.
The
data access plan editor opens.
- Click Data
Privacy.
The privacy policy
editor opens.
- From
the Policies area, do the following:
- Select a Platform that
will process the policy.
- From the Policy list, expand Generic
Lookup Privacy Policies and then click Hash
Lookup.
- From the Attributes list,
select the attribute to mask with the policy.
- Click Apply.
The Add Policy wizard opens.
- Complete the steps of the
wizard.
- You must select a data source connection and enter a DB alias
associated with the lookup table. You must also select the lookup
table schema and name.
- You must map columns in the lookup table to attributes in the
source entity that will be masked.
- You must select an attribute that will provide the values to be
hashed.
- You can specify characters that will be trimmed from the source
value before it is hashed.
- You can enter a seed value to vary the calculation performed by
the hashing algorithm.
- You must select a column in the lookup table that contains values
to match against the search value from the source attribute.