Transformation Guide

Back Next

Creating a Data Store for Identity Index Data

Configure a mapping that reads a data source that contains identity information. Use a Match transformation to write the index data to a database.

Create a mapping, and add the data source to the mapping canvas.

Add a Match transformation to the mapping canvas.

On the data source, select the ports that contain the identity information.

Connect the identity information ports to the Match transformation.

Connect the port that contains the sequence identifier values to the Match transformation.

On the Match transformation, select the

Match Type

view.

Set the match type to

Identity Match with Persistent Record ID

Configure the following options to create the index data store.

Set the persistence method to

Update the database with new IDs

Verify the matching process value. The default value is

Enable

. If you disable the matching process, the mapping creates the identity index tables but does not perform match analysis on the data.

On the DB Connection menu, select a database for the index tables.

On the Persistent Store menu, select

Create New

. Enter a name for the index in the

Create Storage Tables

dialog box.

Perform any other configuration step that the Match transformation requires. For example, configure a transformation strategy.

Add a target data object to the mapping.

Connect the Match transformation output ports to the target data object.

Run the mapping.

The mapping writes the index data for the data source to the database tables that you specify.