Mappings

Back Next

Mapping tutorial

The following tutorial describes how to create a simple mapping, save and validate the mapping, and create a

mapping

task.

For this tutorial, you have a table that contains global customer information. You want to create a table that contains customer information for a specific country.

The following table lists the transformations you'll add to the mapping:

Transformation	Description
Source	Represents the source table that contains customer information.
Filter	Filters out all customer information except for a specific country.
Target	Represents the target table that contains customer information for a specific country.

You create parameters in the mapping so that you can use the same

mapping

task to create different target tables for each country. Create the following parameters:

In the Filter transformation, create a parameter to hold the country value so that you can use the mapping to create multiple tasks. You can specify a different country value for each task.

In the Target transformation, create a parameter for the target object so you can create separate target tables for each country.

After you define the mapping, you create a

mapping

task that is based on the mapping. When you run the

mapping

task, you enter values for the target object parameter and the filter parameter. The

mapping

task writes the data to the chosen target based on the country you select.

Mapping tutorial steps

Preparing for the mapping tutorial

Step 1. Create the mapping

Step 2. Configure the source