We are trying to insert records from a flat file to a table in Teradata. There is a field whose length is 52 characters in flat file and 50 characters in Table. When the field gets inserted it removes the last 2 characters and inserts that record. Ideally the record should be rejected.
Any information about how is happens will be helpful for us.