To improve the mapping performance when you perform identity analysis on two data sets, configure the Match transformation to read identity index data from database tables. Run a mapping to create the index tables for the master data set. Run the mapping again to compare the index data to another data source.
Use the options on the
Match Type
view to identify the database tables that store the index data. Use the same options to select the index tables when you configure the transformation to compare the index data to data from another source.
To write the index data to database tables, perform the following tasks:
Create a mapping that reads a data source of identity information.
Configure a Match transformation in the mapping to write the index data to a database.
Run the mapping to generate the index data. The index data represents a data store that you can reuse.
To read the index data from database tables, perform the following tasks:
Create a mapping that reads another identity data source.
Configure a Match transformation in the mapping to read the index data from the database that you specified earlier.
When the mapping data source and the index data share a common structure, you can reuse the mapping that generated the index data.
Run the mapping to compare the data source to the index data.
The mapping generates index data for the data source. The mapping does not need to generate index data for the larger data set. Therefore, the mapping runs faster than a dual-source mapping that generates index data for both data sets.