Skip to Content
0

comparing row count with source and bods job

Nov 06, 2017 at 10:21 AM

54

avatar image
Former Member

Hi ,

I am loading four .csv files with the * logic in file format to load the data data to one target table with truncate load. In target table I got less data than the count of four tables.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Arun Sasi Nov 06, 2017 at 11:41 AM
0

Cross check the File Format and check the delimiter used.

Share
10 |10000 characters needed characters left characters exceeded
Dirk Venken
Nov 06, 2017 at 12:56 PM
0

Records that don't match the file format specified in DS (e.g. a numeric column containing character data) are not written to the ouput. Make sure to set file format error handling properties according to your needs.

Share
10 |10000 characters needed characters left characters exceeded