Table of Contents

Search

  1. Preface
  2. Transformations
  3. Source transformation
  4. Target transformation
  5. Aggregator transformation
  6. Cleanse transformation
  7. Data Masking transformation
  8. Deduplicate transformation
  9. Expression transformation
  10. Filter transformation
  11. Hierarchy Builder transformation
  12. Hierarchy Parser transformation
  13. Hierarchy Processor transformation
  14. Input transformation
  15. Java transformation
  16. Java transformation API reference
  17. Joiner transformation
  18. Labeler transformation
  19. Lookup transformation
  20. Mapplet transformation
  21. Normalizer transformation
  22. Output transformation
  23. Parse transformation
  24. Python transformation
  25. Rank transformation
  26. Router transformation
  27. Rule Specification transformation
  28. Sequence Generator transformation
  29. Sorter transformation
  30. SQL transformation
  31. Structure Parser transformation
  32. Transaction Control transformation
  33. Union transformation
  34. Velocity transformation
  35. Verifier transformation
  36. Web Services transformation

Transformations

Transformations

Substitution masking

Substitution masking

Substitution masking replaces a column of data with similar but unrelated data. Use substitution masking to replace production data with realistic test data. When you configure substitution masking, select the type of substitution masking based on the data.
The following table describes the substitution masking types that are available:
Name
Description
Substitution Name
Substitutes source data with data from a dictionary file of names.
Substitution Female Name
Substitutes source data with data from a dictionary file of female names.
Substitution Male Name
Substitutes source data with data from a dictionary file of male names.
Substitution Last Name
Substitutes source data with data from a dictionary file of last names.
Substitution Position
Substitutes source data with data from a dictionary file of job positions.
Substitution US ZIP Code
Substitutes source data with data from a dictionary file of U.S. ZIP codes.
Substitution Street
Substitutes source data with data from a dictionary file of street names.
Substitution City
Substitutes source data with data from a dictionary file of U.S. city names.
Substitution State
Substitutes source data with data from a dictionary file of U.S. state names
Substitution Country
Substitutes source data with data from a dictionary file of country names.
The Data Masking transformation performs a lookup on the dictionary file and replaces source data with data from the dictionary. You download the dictionary files when you download the Secure Agent. The dictionary files are stored in the following location:
<Secure Agent installation directory>\apps\Data_Integration_Server\data
You can substitute data with repeatable or nonrepeatable values. When you choose repeatable values, the Data Masking transformation produces deterministic results for the same source data and seed value. You must configure a seed value to substitute data with deterministic results.
You can substitute more than one column of data with masked values from the same dictionary row.