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 file that contains U.S. customer account information. You want to create a file that contains customer account information for a specific state.
In the mapping, you define the following components:
•Source transformation. Represents the source file that contains account information.
•Filter transformation. Transformation that filters out all account information except for a specific state.
•Target transformation. Represents the target file that contains account information for a specific state.
You create parameters in the mapping so that you can use the same mapping task to create files for each state. You create the following parameters:
•In the Filter transformation, you create a parameter to hold the state value so that you can use the mapping to create multiple tasks. You can specify a different state value for each task.
•In the Target transformation, you create a parameter for the target object so that you have separate target files for each state.
After you define the mapping, you create a mapping task that is based on the mapping. When you run the mapping task, you specify values for the target object parameter and the filter parameter. The mapping task then writes the data to the specified target based on the specified state.
The mapping tutorial includes the following steps:
1Create a mapping.
2Configure a source. Specify the name of the source object and the connection to use.
3Create a Filter transformation. Create a parameter in the Filter transformation to hold the state value.
4Configure a target. Specify the connection to use and create a parameter for the target object.
5Validate the mapping to be sure there are no errors. The mapping must be valid before you can run a task based on the mapping.
6Create a task based on the mapping. The task includes parameters for the target object and state value, which you specify when you run the task.