Designer Guide

Back Next

Step 2. Specify Mapping Details and Parameter Values

You can specify the parameter values for each mapping that you want to generate.

To specify the mapping details and the parameter values:

In the first page of the Import Mapping Template Wizard, click the Add button.

In the MappingName field, enter a mapping name.

Optionally, enter a description.

Click the Open button in the Parameters/Values field.

Enter the following information in the Parameters for Mapping dialog box:

Field	Description
Source Table	All available source definitions of the current working directory.
Incremental Extract Condition	Incremental extract condition. For example, enter UPDATE-TS>SYSDATE-1 as incremental extract condition.
Create Target Table	Creates a target table instead of using an existing target table. The target database type will be the same as the source database type.
Target Table	All available target definitions of the repository folder.
Surrogate Key	Primary key of the target table.
Logical Key Fields	Columns of the source table that identify a particular entity.
Comparison Key Fields	Set of fields that identify a changed row between the source and target tables.

The Database Types field shows the type of the database that you selected. You cannot modify this option.

If you use an existing target table, set the field association. To set the field association, click Set Fields Association.

In the Field Association dialog box, click the Add button.

Select the source field from the Source Fields list.

Select the target field from the Target Fields list.

In the Field Association dialog box, click OK.

In the Parameters for Mapping dialog box, click OK.

In the Import Mapping Template Wizard, click Next.

The second page of the Import Mapping Template Wizard displays the list of mappings you configured.