Consider the following rules and guidelines for DB2 Loader objects used as targets in mappings and mapping tasks:
General guidelines
- When you write to a DB2 Loader target table and some rows are rejected due to constraint violation errors, the session log shows incorrect number of rows that are written to the target.
- To load data from a delimited flat file, ensure that the precision of each target table column matches the corresponding source column precision to write all data.
Data types
When you load blank spaces to a DB2 Loader target, the blank spaces are loaded as null values in the Char data type field.
Partitioning
You can't load data to a DB2 target in a mapping enabled for the source partitioning.
Data preview
You can't preview data of a DB2 Loader target object.