Archives of the TeradataForum

Message Posted: Wed, 16 Mar 2005 @ 13:36:19 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

First, the long term solution is to have the job which creates the file eliminate the binary zeroes.

As to specific tactics:

1 Consider having the file created as fixed length fixed format. You can load this file with mload, even if it has binary zeroes in it. Then YOU will have to find and clean the binary zeroes yourself once you have it in a table on teradata.

2 Iteratively mload the file, letting mload tell you which record has the problem and a text editor to fix the records 1 at a time. Make the binary zero data either null or some value appropriate in your situation. There are several text editors available which can handle fairly sizable files (several million rows) if you've got the memory.

I'm not very knowledgeable about the client environments and what utilities might be available to help clean a file. I prefer working on Teradata, where I can find the problem data and clean it myself.

Perhaps someone more knowledgeable of utilities or ETL tools could tell us what may be available to help.

Hope this helps.

Don

	<Prev	Next>		<<First	<Prev	Next>	Last>>