Data linkage from one table to n tables

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

4.2.3 Data linkage from one table to n tables

This section explains the pattern for data linkage from one table to n tables.

Organization of this subsection: (1) Example of dividing a source table into multiple tables and extracting them at the source, and then importing them into a single target; (2) Example of dividing a source table into multiple tables and extracting them at the source, and then importing them into multiple targets; (3) Example of dividing a source table into multiple tables at the target, and then importing them

(1) Example of dividing a source table into multiple tables and extracting them at the source, and then importing them into a single target

The following figure shows an example of dividing a source table into multiple tables and extracting them at the source, and then importing them into a single target.

Figure 4-8 Example of dividing a table into n tables and extracting them at the source, and then importing them into a single target system

[Figure]

Explanation

Dividing a table at the source
To divide a table into multiple tables at the source, specify as many extraction statements as there are divisions of the table.

(2) Example of dividing a source table into multiple tables and extracting them at the source, and then importing them into multiple targets

The following figure shows an example of dividing a source table into multiple tables and extracting them at the source, and then importing them into multiple targets.

Figure 4-9 Example of dividing a source table into multiple tables and extracting them at the source, and then importing them into multiple targets

[Figure]

Explanation

Sending to multiple targets
To send a table to multiple targets, specify as many send statements as there are targets.

(3) Example of dividing a source table into multiple tables at the target, and then importing them

The following figure shows an example of dividing a source table into multiple tables at the target, and then importing them.

Figure 4-10 Example of dividing a source table into multiple tables at the target, and then importing them

[Figure]

Explanation

Dividing a table at the target
To divide a source table into multiple tables at the target, specify as many import table definitions as there are divided tables.
Because mapping keys are needed to establish the correspondence between the source and target tables, specify the mapping key fields in all import table definitions.