Reads data from a source.

Writes data to a target.

A passive transformation that applies access policies created in

Data Access Management

.

An active transformation that performs aggregate calculations on groups of data.

A passive transformation that adds a cleanse asset that you created in

Data Quality

to a mapping or mapplet. Use a cleanse asset to standardize the form and content of your data.

A passive transformation that masks sensitive data as realistic test data for nonproduction environments.

An active transformation that invokes data services from the data services repository, including industry-standard services, such as HL7 and HIPAA, and customized services.

An active transformation that adds a deduplicate asset that you created in

Data Quality

to a mapping or mapplet. Use a deduplicate asset to find instances of duplicate identities in a data set and optionally to consolidate the duplicates into a single record.

A passive transformation that performs calculations on individual rows of data.

An active transformation that filters data from the data flow.

An active transformation that converts relational input into hierarchical output.

A passive transformation that converts hierarchical input into relational output.

An active transformation that converts hierarchical input into relational output, or relational input into hierarchical output, or hierarchical output into hierarchical output of a different schema, or hierarchical input into denormalized flattened output.

A passive transformation that passes data into a mapplet. Can be used in a mapplet, but not in a mapping.

Executes user logic coded in Java.

An active transformation that joins data from two sources.

A passive transformation that adds a labeler asset that you created in

Data Quality

to a mapping or mapplet. Use a labeler asset to identify the types of information in an input field and to assign labels for each type to the data.

Looks up data from a lookup object. Defines the lookup object and lookup connection. Also defines the lookup condition and the return values.

Runs a machine learning model and returns predictions to the mapping.

Inserts a mapplet into a mapping or another mapplet. A mapplet contains transformation logic that you can create and use to transform data before it is loaded into the target.

An active transformation that processes data with multiple-occurring fields and returns a row for each instance of the multiple-occurring data.

A passive transformation that passes data from a mapplet to a downstream transformation. Can be used in a mapplet, but not in a mapping.

A passive transformation that adds a parse asset that you created in

Data Quality

to a mapping or mapplet. Use a parse asset to parse the words or strings in an input field into one or more discrete output fields based on the types of information that the words or strings contain.

Runs Python code that defines transformation functionality. Can be active or passive.

An active transformation that limits records to a top or bottom range.

An active transformation that you can use to apply a condition to incoming data.

A passive transformation that adds a rule specification asset that you created in

Data Quality

to a mapping or mapplet. Use a rule specification asset to apply the data requirements of a business rule to a data set.

A passive transformation that generates a sequence of values.

A passive transformation that sorts data in ascending or descending order, according to a specified sort condition.

Calls a stored procedure or function or executes a query against a database.

A passive transformation that analyzes unstructured data from a flat file source and writes the data in a structured format.

An active transformation that commits or rolls back sets of rows during a mapping run.

An active transformation that merges data from multiple input groups into a single output group.

A passive transformation that executes a Velocity script to convert JSON or XML hierarchal input from one format to another without flattening the data.

A passive transformation that adds a verifier asset that you created in

Data Quality

to a mapping or mapplet. Use a verifier asset to verify and enhance postal address data.

An active transformation that connects to a web service as a web service client to access, transform, or deliver data.