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. Data Services transformation
  9. Deduplicate transformation
  10. Expression transformation
  11. Filter transformation
  12. Hierarchy Builder transformation
  13. Hierarchy Parser transformation
  14. Hierarchy Processor transformation
  15. Input transformation
  16. Java transformation
  17. Java transformation API reference
  18. Joiner transformation
  19. Labeler transformation
  20. Lookup transformation
  21. Machine Learning transformation
  22. Mapplet transformation
  23. Normalizer transformation
  24. Output transformation
  25. Parse transformation
  26. Python transformation
  27. Rank transformation
  28. Router transformation
  29. Rule Specification transformation
  30. Sequence Generator transformation
  31. Sorter transformation
  32. SQL transformation
  33. Structure Parser transformation
  34. Transaction Control transformation
  35. Union transformation
  36. Velocity transformation
  37. Verifier transformation
  38. 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.

0 COMMENTS

We’d like to hear from you!