Mapping columns to a new Target Table

Mapping columns to a new Target Table includes:

  • Opening a CONNX Data Dictionary (CDD)

  • Viewing, and if necessary, changing some of the target table metadata

 

Map columns to a new Target Table if:

  • You wish to change the target table metadata so it is different than the source table metadata

  • You don't need all of the source columns replicated to the target table

 

After you map columns to a new Target Table you will be able to:

  • Create the target table

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

 

A target table is considered to be "new" if it does not exist on the target data base and it has not been created or deployed.

 

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 the column source and the column attributes.

 

Warning: Since the Event Replicator cannot create Adabas Target Tables, you cannot map columns to a new Adabas Target Table. All Adabas Target Table changes must be done using Adabas, not the Event Replicator.

 

  1. Open the Open Systems Event Replicator CDD.

  1. Select a Target Table to view. Click Map Columns. The Map Columns window appears.

Map_Columns_main_screen.bmp

 

    • The Index entry is used to indicate if a field will be part of the target table index. Even if your source table contains multiple index fields, you can only use a single unique index for replication. You can indicate the index order by designating "1" as the first part of the index, "2" as the second part of the index (if necessary), and so on. A zero means this field is not part of the index.

    • The Source Column names are pre-populated and cannot be changed.

    • Select the correct SQL data type in Source and Target Data Type.

    • You can change the Source and Target Length, Precision and Scale values if they are incorrect.

    • Target Column is pre-populated with the same name as the Source Column. This name can be changed.

Note: You cannot use the Open Systems Event Replicator to change the order of the rows in the Source Table.