Data mapping

The Configure Data Mapping dialog allows you to configure settings in a selected source-target configuration file.

File panel

The Data Assistant file properties define the active source-target configuration file and enable you to further configure the source dataset, target dataset, and replace settings.

The following Data Assistant methods can be configured in your data migration project:

Property Description
Source-Target Configuration File The active source-target configuration file for Data Mapping.
Source Layer The path to the source layer for the active configuration file.
Replace By Field Value When enabled, defines the selection query for the target layer that will be used when the Replace Data tool is executed.
Target Layer The path to the target layer for the active configuration file.

Fields panel

The Data Assistant field methods define the actions to occur when migrating data from a source dataset to a target dataset. They can be used to populate new values in the target dataset or perform more advanced field mapping that may be necessary when the target dataset has a different data structure.

The following Data Assistant methods can be configured in your data migration project:

Method Description
Copy Copy source field values to target fields.
Default Value Sets a default value for a field.
Value Map Set target values based on source value.
Change Case Change the case of the source text string.
Concatenate Concatenate source values into a string.
Left Extract a number of characters from the left.
Right Extract a number of characters from the right.
Substring Extract a set of characters from a string.
Split Split a string into parts and use one part.
Conditional Value Construct an if/else statement.
Domain Map Load and map domains values.
Top