Transformations¶

Overview¶

A transformation is a project component that is used as a step in an operation to map or transform inputs to a resulting output by moving data, cleaning data, or applying business logic. A transformation consists of source and target schemas that have been defined in the transformation and the transformation mapping that generates the output.

If you don't want to transform data and instead pass through data unchanged, you don't need to add a transformation. Valid operation patterns are provided in Validation Patterns under Operation Validity.

These sections or pages are included in this topic:

• Transformation Basics
  Learn about general concepts that are helpful to understand during the transformation configuration process. Topics include data structures, nodes and fields, and transformation processing types.

• Transformation Creation and Configuration
  This page explains the parts of a transformation, then covers creating a new transformation and accessing the menu options that are available once a transformation is created.

• Transformation Display Modes
  There are three display modes for accessing a transformation: mapping, script, and preview mode. Mapping and script modes provide tools for configuring the transformation, while preview mode provides tools for testing the transformation with sample data. In addition, some elements of the user interface are common to all display modes.

• Transformation Mapping
  Transformation mapping consists of target fields or nodes and their corresponding scripts. These scripts may contain references to source fields or nodes or to project components, use functions, or contain other valid script logic. A mapping does not include target fields that are not mapped.