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:
Performs aggregate calculations.
Joins data from different databases or flat file systems.
Looks up and returns values from a relational table or a file.
Limits records to a top or bottom range.
Routes data into multiple transformations based on group conditions.
Sorts data based on a sort key.
Represents the rows that the Integration Service reads from a relational or flat file source when it runs a workflow.
Calls a stored procedure.
Merges data from multiple databases or flat file systems.
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.