Changing target column mappings includes: Opening a CONNX Data Dictionary (CDD) Changing which target column a source column is mapped to   Change the target column mappings if: You wish to change which target column a source column is mapped to   After you change the column mappings you will be able to: Deploy the replication (which will start replicating data from source database to target database)

 

When the Event Replicator creates a Target Table, it assigns column source and attributes based on the associated Source Table. Map Columns allow you to change which target column a source column is mapped to

 

Note: The Source and Target columns must have compatible data types, length, precision and scale.

 

Note: You can not use the column mapper to delete a column from the Source Table.

 

1. Open the InstantdbSync Replication Administrator

2. Select a replication to modify. Click Map Columns. The Map Columns window for an existing target table appears.

 

3. Under Populate columns, click Target Columns.
   In this example, the target table has two columns that do not exist in the source table (FIRSTNAME and LASTNAME).  By populating the target columns, these two columns become visible and do not have any default mapping to corresponding source columns.

 

4. Click the Target Column box for the column you wish to change. A drop down arrow appears. Click on the arrow and a list of available source column names appears.  Select the target column name to map the corresponding target column to.

 

6. The selected Source Column will map to the corresponding Target Column..

 

7. You can also map either existing source columns or an SQL expression to the two columns that exist in the target table but not the source.  In this example, we have use the SUBSTRING expression to fill FIRSTNAME and LASTNAME.
   
   
    

8. Click Done. The InstantdbSync main window reappears.