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 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:

Create a mapping.

Configure a source. Specify the name of the source object and the connection to use.

Create a Filter transformation. Create a parameter in the Filter transformation to hold the state value.