Tasks

Back Next

Random date masking

Random date masking produces random, non-repeatable results for the same source date.

You can assign a minimum and a maximum date for the results. You can also configure blurring to define a variance limit for the date results.

The following table describes the parameters that you can configure for random date masking:

Masking parameter	Description
Range	A range that you want to specify for the date data. Select the check box to set minimum and maximum values for a datetime value.
Minimum Range	The minimum value to return for the selected datetime value. The default datetime format is MM/DD/YYYY HH24:MI:SS.
Maximum Range	The maximum value to return for the selected datetime value. The maximum datetime must be later than the minimum datetime.
Blurring	Mask a date as a variance of the source date.
Blurring Unit	Unit of the date to apply the variance to. Select the year, month, day, or hour. Default is year.
Low Bound	The low boundary of the variance from the source date.
High Bound	The high boundary of the variance from the source date.

Date blurring

To blur a datetime source value, select a unit of time to blur, a high bound, and a low bound. You can select year, month, day, or hour as the unit of time. By default, the blur unit is year.

For example, to restrict the masked date to a date within two years of the source date, select year as the unit. Enter two as the low and high bound. If a source date is 02 February, 2006, the

masking

task returns a date between 02 February, 2004 and 02 February, 2008.

Random masking

Download Guide

Watch

Comments

Cloud Data Integration Homepage