on 11-06-2017 10:21 AM
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Cross check the File Format and check the delimiter used.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.