Mappings

Back Next

Step 5. Validate and test the mapping

In the following procedure, you save and validate the mapping and then you test run the mapping.

You can save a mapping that is not valid. However, you cannot run a task that uses a mapping that is not valid. An example of an invalid mapping is a Source transformation or Target transformation that does not have a specified connection, or a mapping that does not have a Source transformation and a Target transformation.

To validate the mapping, click

Save

Whenever you save the mapping, the Mapping Designer validates the mapping. The status of the mapping displays in the header next to the mapping name. The mapping status can be Valid or Invalid.

If the mapping is not valid, perform the following steps:

In the header, click the

Validation

icon to open the

Validation

panel.

The

Validation

panel lists the mapping and the transformations used in the mapping and shows where the errors occur. For example, in the following image, the tgt_Accounts_by_State Target transformation has an error:

After you correct the errors, save the mapping and then in the

Validation

panel, click

Refresh

. The

Validation

panel updates to list any errors that might still be present.

To test the mapping, click

Run

The mapping canvas shows a complete mapping with the Source, Filter, and Target transformations. When the mapping is valid, you can click Run.

In the wizard, select the runtime environment and click

In the first page of the wizard, you select the runtime environment to use to run the mapping. The wizard displays an image of the mapping.

The

Targets

page appears. The

Targets

page appears because the target is parameterized. If you create a mapping that does not include a parameterized target, you will not see the

Targets

page when you run the mapping.

The parameter you created for the target object displays on the page with the Accounts for State label, as you specified when you created the parameter.

You can select a target object or create a new target object. For this tutorial, let's create a new target object that will include accounts for Texas.

On the

Targets

page, click

Create Target