Linking data to a table with a different format

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

3.1.2 Linking data to a table with a different format

This section explains by way of examples data linkage to a table with a different format.

Organization of this subsection: (1) Rearranging the columns; (2) Importing selected columns; (3) Adding a column with a fixed value

(1) Rearranging the columns

The following figure shows an example of importing data and rearranging the source table's columns. To rearrange columns, you define the linkage pattern either in the source system or the target system.

Figure 3-3 Example of importing data and rearranging the columns

[Figure]

(2) Importing selected columns

The following figure shows an example of importing selected columns from the source table. To import selected columns, you define the linkage pattern either in the source system or the target system.

Figure 3-4 Example of importing selected columns

[Figure]

(3) Adding a column with a fixed value

The following figure shows an example of adding a column with a fixed value during data import processing. To add a fixed-value column, you define the linkage pattern in the target system.

Figure 3-5 Example of adding a column with a fixed value

[Figure]