Is there a good way to handle invalid data when using multiload ie :-( ......) coming in on an MVS flat file. some records return 'out of range error' on one particular field, and others have data. or is the best solution to have the file fixed?
AFAIK its a business decision which you and your client both have to take, to make sure data is getting loaded in EDW properly. what i mean to say is , for some fields you are getting out of range error. this kind of errors occur when in TD table column has length say decimal(10,2) and you are trying to insert data of length decimal (11,2). In source you may have provision to accomodate such data but not in Teradata. As per my knowledge this is a mapping issue where we map the source field with TD tables.