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.
ASK INFAPreview
