[resolved] Records with data truncation error not treated as rejected.
Hi, I have designed a job that reads data from a CSV file and outputs it into a database table using tMap. In the schema defined for the CSV file the data type for all fields is String and their length is not specified. However the schema of the database table is defined with accurate field lengths. In the tMap, I have added variables for database fields whose datatype is not VARCHAR. I have also unchecked the Die on error setting in the tMap configuration and the ErrorReject output is directed to a different CSV file. When I execute the job, if there are any records that fail in the tMap transformation (String to Date or int or float or some other datatype) then those records are marked as rejected and are transferred to the CSV output file. However if the string value read for a field is longer than the specified database length then an error message is displayed but the record is not marked as rejected. How can I mark these records are rejected and move them to the output CSV file?