Clearing Source Column Mapping

Clearing source column mappings includes:

  • Opening a CONNX Data Dictionary (CDD)

  • Clearing the target columns

 

Clear the source column mappings if:

  • The default target mappings are incorrect

 

After you clear the source mappings you will be able to:

  • Select the correct target columns to map to the source columns

  • Deploy the replication (which will start replicating data from source database to target database)

 

Map Columns allow you to change which source column a target column is mapped to.

 

If you wish to change most of the source column mapping in a Target Table, you may find it easier to start with blank Target column names. The column names will still appear in the drop-down list.

 

  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 Source Column.

  2. Click Clear Target. The Target Column names are blanked out.

Map_Columns_clear_target.bmp