HiRDB Datareplicator Version 8 Description, User's Guide and Operator's Guide

[Contents][Glossary][Index][Back][Next]

5.13.4 Examples of source and target definitions

This section explains by way of examples the following source and target definitions:

These examples use the source table's form number (FNO) column as the mapping key.

Organization of this subsection
(1) Selecting and resorting columns at the source
(2) Selecting and resorting columns at the target
(3) Adding a column (fixed value) at the target
(4) Dividing one table into two tables at the target
(5) Dividing one table into two tables at the source
(6) Importing two tables into one table at the target

(1) Selecting and resorting columns at the source

The following figure shows an example of source and target definitions when data linkage is used for selecting and resorting the source table's columns at the source.

Figure 5-22 Example of source and target definitions: Selecting and resorting columns at the source

[Figure]

(2) Selecting and resorting columns at the target

The following figure shows an example of source and target definitions when data linkage is used for selecting and resorting the source table's columns at the target.

Figure 5-23 Example of source and target definitions: Selecting and resorting columns at the target

[Figure]

(3) Adding a column (fixed value) at the target

The following figure shows an example of source and target definitions when data linkage is used for adding a column (fixed value) to the source table at the target.

Figure 5-24 Example of source and target definitions: Adding a column (fixed value) at the target

[Figure]

(4) Dividing one table into two tables at the target

The following figure shows an example of source and target definitions when data linkage is used for dividing one source table into two tables at the target.

Figure 5-25 Example of source and target definitions: Dividing one table into two tables at the target

[Figure]

(5) Dividing one table into two tables at the source

The following figure shows an example of source and target definitions when data linkage is used for dividing one source table into two tables at the source.

Figure 5-26 Example of source and target definitions: Dividing one table into two tables at the source

[Figure]

(6) Importing two tables into one table at the target

The following figure shows an example of source and target definitions when data linkage is used for combining two source tables into one table at the target.

Figure 5-27 Example of source and target definitions: Combining two tables into one table at the target

[Figure]