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

Mapplet masking

Mapplet masking

You can assign a mapplet rule to the source fields to mask the output target fields.
A mapplet can contain multiple input and multiple output ports. A task fails if you do not configure any of the mapplet input or output ports that you add to a source object.
After you add a mapplet rule and assign the rule to a field, you must configure the mapplet parameters. Map the source fields to the input fields of the mapplet, and map the output fields of the mapplet to the target fields.
For example, an email mapplet contains the logic to concatenate the first name and last name of the source object to generate an email ID. Apply the email mapplet masking rule to the source fields. Map the FirstName3 input field of the source to the FirstName field of the mapplet. Map the LastName3 input field of the source to the LastName field of the mapplet. Map the Email output field of the mapplet to the Email3 field of the target.
The following image shows the mapplet parameters that you can configure:
The Configure Mapplets dialog box shows a sample email mapplet with the source fields mapped to mapplet input fields and mapplet output field mapped to the target output field.
You can use a passive mapplet that requires an extra connection to a relational database or a flat file. For example, mapplets that contain an SQL transformation, lookup transformation, or a data masking transformation that uses a dictionary connection. Before you add the mapplet, you must create the connection. When you configure a mapplet that requires an extra connection, you must configure the dictionary, SQL, or lookup connections. You select the connection reference based on the type of connection that the mapplet contains.
For example, you want to mask an account name with an AccountNameMapplet mapplet and the mapplet has connections to a dictionary and a relational database. After you add the mapplet and the connections, configure and assign the mapplet to the target. After you select the AccountNameMapplet mapplet, select the AccName_Lookup connection to perform the lookup operation. Select the AccName_Dict_Con connection to read the values from the dictionary connection. Map the Account Name input source field to the input mapplet field. Map the mapplet output port to the Account Name target field.
The following image shows the mapplet that contains the dictionary and lookup connections:
The Configure Mapplets dialog box shows a sample account name mapplet with the lookup and dictionary connection reference parameters, source fields mapped to mapplet input fields, and mapplet output field mapped to the target output field.
If the dictionary information for the mapplet is in a flat file, the flat file must be present in the following location:
<Secure Agent installation directory>\apps\Data_Integration_Server\data
If the lookup connection for the mapplet is a flat file connection, the connection name must be the name of the flat file.

0 COMMENTS

We’d like to hear from you!