Mappings

Back Next

Step 4. Configure a target

In the following procedure, you create a parameter for the target object so that each time you run the

mapping

task, you can select a different target.

For example, you might want files that only include data for the states you specify in the filter parameter when you run the

mapping

task. When you run the task, if you filter for accounts in California, you can select the file that contains data for California accounts as the target.

On the mapping canvas, click the Target transformation to select it.

To name the Target transformation, in the

Properties

panel, click

General

and enter

tgt_Accounts_by_State

for the Target transformation name.

Click

Target

and configure the following properties:

Target detail	Description
Connection	Connection to the target file. You want the target object to be a flat file and you want the target object to reside in the same location as the source file. You can use the same connection that you used for the source because the source is a flat file as well.
Target Type	Target object or parameter. You want to parameterize the target object so that you can have separate files for each state, so select Parameter .
Parameter	Parameter to use for the target object. This field only appears when you select Parameter as the target type. Click New Parameter , and for the parameter name, enter p_StateTargetParameter . For the display label, enter Accounts for State . Click OK .

The following image shows the properties for the tgt_Accounts_by_State Target transformation:

The Properties panel for tgt_Accounts_by_State shows the settings you made for the target connection, target type, and parameter.

Click

Field Mapping

and for

Field map options

, select Automatic. You cannot specify field mappings because the target object is parameterized. Because you can select different target objects each time you run the task, the fields in the target objects might not be the same each time you run the task.

Click

Save

. You now have a complete mapping.

Mapping tutorial

Download Guide

Watch

Comments

Cloud Data Integration Homepage