I created a flat file and now need to load that data to teradata table. But while importing the script was facing "Failure 2673 The source parcel length does not match data that was defined error"
My data in the file :
Try below and reply whether it has worked.
remove filler (char(1))
change reslt varchar(11) in table
Thank you.It worked :)
But can you please tell me the reason as why to change change reslt varchar(11) in table.
what difference does it made/ :( And as per my knowledge Teradata internally insert data as per datatype of columns.
Good to hear that it has worked. You are right, the 2nd option is not required.
Just one curiosity , are you using TD 14 ?