Verifies and enhances the accuracy of postal address records, and adds information that helps users to select the mail recipients and to deliver the mail.

Creates links between the duplicate records that a Match transformation assigns to different clusters.

Performs aggregate calculations.

Identifies records that might contain data errors, and loads the records to tables that an Analyst tool user can review and update.

Standardizes the case of strings.

Writes labels that summarize the information in input port fields. Use when the fields contain significant amounts of text.

Generates numeric scores that indicate the degree of similarity between pairs of input strings.

Creates a consolidated record from records identified as duplicates by the Match transformation.

Replaces sensitive production data with realistic test data for non-production environments.

Processes unstructured and semi-structured file formats in a mapping.

Evaluates conditions in input data and creates output based on the results of those conditions.

Identifies records that might contain duplicate information, and loads the records to tables that an Analyst tool user can review and update.

Calculates a value.

Filters data.

Processes hierarchical input and transforms it into relational output.

Executes user logic coded in Java. The repository stores the byte code for the user logic.

Joins data from different databases or flat file systems.

Assigns records to groups based on data values in a column that you select.

Writes labels that describe the characters or strings in an input port field.

Look up and return data from a flat file, logical data object, reference table, relational table, view, or synonym.

Generates scores that indicate the degrees of similarity between input records.

Reads the data values from multiple input columns and creates a single output column.

Processes source rows that contain multiple-occurring data and returns a target row for each instance of the multiple-occurring data.

Defines mapplet output rows.

Parses the values on an input port into separate output ports based on the types of information that the values contain.

Limits records to a top or bottom range.

Reads data from a source.

Processes relational input and transforms it into hierarchical output.

Connects to a REST web service as a web service client to access or transform data

Routes data into multiple transformations based on group conditions.

Generates a numeric sequence of values.

Sorts data based on a sort key.

Executes SQL queries against a database.

Generates standardized versions of input strings.

Merges data from different databases or flat file systems.

Determines whether to insert, delete, update, or reject rows.

Connects to a web service as a web service client to access or transform data.

Reads the match scores that a Match transformation generates for the records in a data set, and calculates an average score for each pair of records. You can apply different weights to the scores that the transformation generates for each pair of records.

Represents a target that the mapping writes data to.