Table of Contents


  1. Preface
  2. Working with Transformations
  3. Aggregator Transformation
  4. Custom Transformation
  5. Custom Transformation Functions
  6. Data Masking Transformation
  7. Data Masking Examples
  8. Expression Transformation
  9. External Procedure Transformation
  10. Filter Transformation
  11. HTTP Transformation
  12. Identity Resolution Transformation
  13. Java Transformation
  14. Java Transformation API Reference
  15. Java Expressions
  16. Java Transformation Example
  17. Joiner Transformation
  18. Lookup Transformation
  19. Lookup Caches
  20. Dynamic Lookup Cache
  21. Normalizer Transformation
  22. Rank Transformation
  23. Router Transformation
  24. Sequence Generator Transformation
  25. Sorter Transformation
  26. Source Qualifier Transformation
  27. SQL Transformation
  28. Using the SQL Transformation in a Mapping
  29. Stored Procedure Transformation
  30. Transaction Control Transformation
  31. Union Transformation
  32. Unstructured Data Transformation
  33. Update Strategy Transformation
  34. XML Transformations

Transformation Guide

Transformation Guide

System and Search Configuration

System and Search Configuration

After you connect to the Search Server, you choose the system and search and match parameters.
You can change these parameters on the
IR Settings
tab after you create the transformation.


Choose the system in the Rulebase. A system is the highest level logical definition in an IIR Rulebase.

Search Definition

Choose the search definition that contains the rules for the system. The search definition resides in a system and contains the rules to search, match, and display records.

Search Width

Choose the search width that determines the scope of the search that you want to conduct.
The following table describes the search widths that you can choose:
Search Width
Provides a narrow search with a quick response time. Use this option when you have a low risk associated with missing a match, when you do not require a high match accuracy, or when the data volume is large and response time is critical.
Provides a balance between quality and response time. Use this option for online or batch transaction searches. Default is typical.
Provides a detailed search with an extended response time. Use this option when you have a high risk associated with missing a match, when data quality is a concern, or when the data volume is low and response time is not critical.

Match Tolerance

Choose the match tolerance that determines how aggressive the matching scheme is to select candidate records.
The following table describes the match tolerance options that you can choose:
Match Tolerance
Delivers a candidate match with a set of possible methods for processing. Response time for processing is more. Use this option when you need to find a match even it contains errors and variation.
Delivers matches that are not excessive or extreme. Use for online or batch transaction searches.
Delivers close matches. Use in batch systems when you need an accurate match.
Delivers matches with a higher degree of variation than the typical level. Use in systems where the risk of missing a match is high and when you can review results.


We’d like to hear from you!