Overview
Mapping the fields of the source table to the target table in a replication allows you to specify how you want to map fields. Replicate Preview automatically maps fields and its datatypes to the target tables with the corresponding field attributes from the source tables. However, you can also specify how the field attributes, such as the field name must be created in the target table based on the source and target datastores when you map explicitly.
The Field Mappings dialog box displays the following column in the grid:
Column Name | Description |
|---|---|
Source Name | Displays field names available in the source table. |
Source Type | Data types of the corresponding fields in the source table. |
Target Name | Displays field names for the fields that will be created in the target table. Double-click to modify the target field name. |
Target Type | Data types for the corresponding target fields to be created in the target table. |
Columns in grids throughout the Syniti Knowledge Platform (SKP) can be individually customized, sorted, and filtered. You can also search for names or values for in columns that have the Search feature enabled. The selected settings are remembered per user. Refer to SKP Grid Searching, Sorting, and Filtering for more information.
To perform field mappings:
In the Replications panel, select a replication and click the Map Fields icon. The Field Mapping dialog box is displayed with the list of fields available in the source table of the selected replication.
From the Field Mapping Rules list, select the mapping method as required:
Field Mapping Rule
Description
When to Use
Map By Name
This rule is selected by default and aids in creating tables in the target datastore for the first time.
Fields in the source and target tables are mapped based on their names. For example, if the source table has a columnCustomerID, it will be mapped toCustomerIDin the target table, regardless of their order.Select this rule and skip to Step 4.
When field names are consistent across both tables.
Map By Ordinal
Fields are mapped based on their position (order) in the table rather than their names. For example, the first field in the source table maps to the first field in the target table, the second to the second, and so on, even if their names are different.
Note
This rule is only displayed when the target table associated with the source table is already available in the target datastore.
Select this rule and skip to Step 4.
When source and target tables have the same structure but different field names.
Map Explicit
Manual mapping, allowing control over selecting source fields and modifying target fields.
When you want to enter custom target fields names.
If you select Map Explicit, then verify the selected source tables for replication and complete the following steps:
If you want to specify a different field name for the selected source field on the target table, double-click the required Target Name text box and enter an appropriate target field name.
Note
By default, Syniti Replicate uses the same field attributes of the source table for the target table’s name and datatype.
Select another record in the grid and repeat the Step 3a.
Click Save.
The required fields with its associated field attributes of the source table is mapped to the target table successfully.