Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: MLoad & Removing Binary Zeros
From:   Stubbs, Donald

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.


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023