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.