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

Custom masking

Custom masking

Custom masking applies an expression to mask the target data. Use custom masking to mask string, numeric, and date data types.
When you apply custom masking to a field, click
Configure
and enter the expression. You can select the source fields, operators, and functions to build an expression. When you select a function, you can view the function description and the syntax.
You can concatenate data from multiple source fields to create a masked value for the target field. For example, you need to create a login name. The source has FirstName and LastName fields. Use substitution masking to mask the first and last names. In the Login field, configure an expression to concatenate the first letter of the first name with the last name:
CONCAT(SUBSTR(FirstName,1,1),LastName)
To mask field input values with null values, use custom masking. In the expression builder, enter single quotes separated by a space in the following format:
' '
For more information about configuring expressions, see Field expressions

0 COMMENTS

We’d like to hear from you!