I'm trying to import data from a csv file into Teradata using tdload utility with the following command:
tdload -h TDPID -u dbc -p dbc -t DemoTable -f demofile.csv -d ','
--TargetWorkingDatabase AdventureWorksDW --TargetErrorLimit 100 jobid
I get the error :
Field length overflow(s) in record 1, field 1, '"ID"'. Expected 11 bytes,
field contained 26 bytes.
How do I fix this?
Note - ID is an INTEGER column