Table of Contents

Search

  1. Preface
  2. Data integration tasks
  3. Mapping tasks
  4. Dynamic mapping tasks
  5. Synchronization tasks
  6. Data transfer tasks
  7. Replication tasks
  8. Masking tasks
  9. Masking rules
  10. PowerCenter tasks

Tasks

Tasks

Random date masking

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.

0 COMMENTS

We’d like to hear from you!