Getting Started

10.5.1
- 10.5
- 10.4.0

Back Next

Using Transformations

In this lesson, you create a mapping that contains a source, multiple transformations, and a target.

A transformation is a part of a mapping that generates or modifies data. Every mapping includes a Source Qualifier transformation, representing all data read from a source and temporarily stored by the Integration Service. In addition, you can add transformations that calculate a sum, look up a value, or generate a unique ID before the source data reaches the target.

The following table lists some of the transformations that you can create:

Transformation	Description
Aggregator	Performs aggregate calculations.
Expression	Calculates a value.
Filter	Filters data.
Joiner	Joins data from different databases or flat file systems.
Lookup	Looks up and returns values from a relational table or a file.
Rank	Limits records to a top or bottom range.
Router	Routes data into multiple transformations based on group conditions.
Sequence Generator	Generates primary keys.
Sorter	Sorts data based on a sort key.
Source Qualifier	Represents the rows that the Integration Service reads from a relational or flat file source when it runs a workflow.
Stored Procedure	Calls a stored procedure.
Union	Merges data from multiple databases or flat file systems.
Update Strategy	Determines whether to insert, delete, update, or reject records.

In this lesson, you complete the following tasks:

Create a target definition to use in a mapping and create a target table based on the new target definition.

Create a mapping using the target definition. Add the following transformations to the mapping:

Lookup transformation. Finds the name of a manufacturer.

Aggregator transformation. Calculates the maximum, minimum, and average price of items from each manufacturer.

Expression transformation. Calculates the average profit of items, based on the average price.

Learn some tips for using the Designer.

Create a session and workflow to run the mapping and monitor the workflow in the Workflow Monitor.

Rename Saved Search

Table of Contents

Getting Started

Getting Started

Using Transformations

Using Transformations