cancel
Showing results for 
Search instead for 
Did you mean: 

comparing row count with source and bods job

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member187605
Active Contributor
0 Kudos

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.

former_member198401
Active Contributor
0 Kudos

Cross check the File Format and check the delimiter used.