Changing Target Column Mapping

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, lengths, precisions and scales.

 

Note: You can not use the Open Systems Event Replicator to delete a row from the Source Table.

 

  1. Open the Open Systems Event Replicator CDD.

  1. Select a Target Table to modify. Click Map Columns. The Map Columns window for an existing target table appears.

Map_columns_existing_source_columns.bmp

 

  1. Under Populate columns, click Target Columns.

Map_columns_existing_target_columns.bmp

 

  1. Click the Target Column box for the replication you wish to change. A drop down arrow appears. Click on the arrow and a list of available source column names appears.

Map_columns_existing_target_name_dropdown.bmp

 

  1. Select the target column name to map the corresponding target column to.

Map_columns_existing_target_name_dropdown.bmp

 

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

Map_columns_existing_target_name_changed.bmp

 

  1. Click Done. The Open Systems Event Replication window reappears.

Note: The ISN field is always shown in the column map because replication requires a unique key present to work and if there are no other unique keys on the table the ISN can then be used.  The ISN is shown even if the table was built with a Create Table statement that did not specify an ISN.