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 database and it has not been created or deployed.
When Adabas Event Replicator for LUW 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.
CAUTION:
Adabas Event Replicator for LUW cannot create Adabas Target Tables, therefore you cannot map columns to a new Adabas Target Table. All Adabas Target Table changes must be done using Adabas, not Adabas Event Replicator for LUW.
To map columns to a new target table:
1. Open the Adabas Event Replicator for LUW CDD.
2. Select a Target Table to view. Click Map Columns. The Map Columns window appears:
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 the source and target
Data Type fields.
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 Adabas Event Replicator for LUW to change the order of the rows in the Source Table.