Designer Guide

10.5
- 10.5.6
- 10.4.1
- 10.4.0

Back Next

Steps to Create a Slowly Growing Target Mapping

To create a slowly growing target mapping:

In the Mapping Designer, click Mappings > Wizards > Getting Started.

Enter a mapping name and select Slowly Growing Target, and click Next.

The naming convention for mapping names is m_
MappingName
.

Select a source definition to be used in the mapping.

All available source definitions appear in the Select Source Table list. This list includes shortcuts, flat file, relational, and Application sources.

Enter a name for the mapping target table. Click Next.

The naming convention for target definitions is T_
TARGET_NAME
.

Select the column or columns from the Target Table Fields list that you want the Integration Service to use to look up data in the target table. Click Add.

The wizard adds selected columns to the Logical Key Fields list.

The columns you select should be a key column in the source.

When you run a workflow containing the session, the Integration Service performs a lookup on existing target data. The Integration Service returns target data when Logical Key Fields columns match corresponding target columns.

To remove a column from Logical Key Fields, select the column and click Remove.

You cannot add a port using the name, FILLER, to the Logical Key field list.

Click Finish.

The new mapping appears in the workspace. Make necessary edits to the mapping.

The Fields to Compare for Changes field is disabled for the slowly growing target mapping.

Rename Saved Search

Table of Contents

Designer Guide

Designer Guide

Steps to Create a Slowly Growing Target Mapping

Steps to Create a Slowly Growing Target Mapping