ObjectMap parameters
For each target table that has a different definition than your source table, you must specify a set of [ObjectMap] parameters. If you do not include an [ObjectMap] section, the High-speed Apply Engine uses the source object names as the target names.
Parameter | Reference |
|---|---|
SourceColumn (SC) | |
SourceTable (ST) | |
TargetColumn (TC) | |
TargetTable (TT) |
The following figure shows an example of the [ObjectMap] parameters values. Example of [ObjectMap] parameters (column only) shows how to change the name of a column without changing the name of the table that contains the column.
To specify object mapping parameters for Db2 objects with long names, you might need to use multiple lines in your configuration file. For more information, see Overview of the configuration file’s format.
Important
Be aware of the following considerations when specifying [ObjectMap] parameters:
Do not specify [ObjectMap] parameters if your input contains data definition language (DDL) statements in SQL input (or DDL objects in logical log input). Due to processing constraints, High-speed Apply Engine does not support the combination of object mapping and DDL input.
A logical log file generated with overtime mode might contain multiple instances of the same object, (for example, a table that was dropped and then recreated). Therefore, you should not specify [ObjectMap] parameters for a table with multiple instances.
If you specify table names only, all columns are included and the target table columns are same as the source table columns. If all column names in target table are different from those in the source table, you must map all columns manually. If one column name is different in the target table from the source table, you have to specify only that column in object mapping. All other columns are still used and are assumed to have the same name on the source and the target tables.
Important
When you map column names except one or more, that one target column name becomes the default name as the source table. You cannot exclude a column from object mapping.
[ObjectMap]
SourceTable=ACCTG.EMPLYE
TargetTable=SYS14.EMPLOY
SourceColumn=NAME
TargetColumn=EMPNAME
SourceTable=ACCTG.PAYROLL
TargetTable=SYS14.PAYROLL
SourceColumn=SALARY
TargetColumn=PAYRATE [ObjectMap]
SourceTable=ACCTG.EMPLYE
TargetTable=ACCTG.EMPLYE
SourceColumn=NAME
TargetColumn=EMPNAME
Comments
Log in or register to comment.