Skip to Content
avatar image
Former Member

comparing row count with source and bods job

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 06, 2017 at 11:41 AM

    Cross check the File Format and check the delimiter used.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 06, 2017 at 12:56 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded