Table of Contents

Search

  1. Preface
  2. Product Overview
  3. Before You Begin
  4. Tutorial Lesson 1
  5. Tutorial Lesson 2
  6. Tutorial Lesson 3
  7. Tutorial Lesson 4
  8. Tutorial Lesson 5
  9. Tutorial Lesson 6
  10. Naming Conventions
  11. Glossary

Getting Started

Getting Started

Using Transformations

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:
  1. Create a target definition to use in a mapping and create a target table based on the new target definition.
  2. 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.
  3. Learn some tips for using the Designer.
  4. Create a session and workflow to run the mapping and monitor the workflow in the Workflow Monitor.

0 COMMENTS

We’d like to hear from you!