Hi Mary,
Your individual scenario may differ but as a thumb rule, use a Segmented Mapping Algorithm with segments wide enough for the
Max width of the value inside that column. An SM algo should be used for any column with a Unique Index on it.
e.g for a
10 digit value we may create an SM algo with
3 Alphanumeric Segments of width
3X3X4.
The
UQ constraints/Indices needs to be disabled during the period while masking job is running.