Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 08 Nov 2013 @ 12:28:35 GMT


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


Subj:   Re: Characters rejected by Fastload
 
From:   Khongthaw, Raja

Hi,

How about seeing them in error table ?

How about increasing the errlimit maybe around 100000 records and at one go read the entire errored out file and correct them.

Also put checkpoint if necessary.

See that you may need to correct the second error table too.

Since I am comfortable in unix, so I used to correct the bad characters using vi and sed.

There was a time when the file was too huge, I could not do it reading AbInitio. So it was hard to find, then. If now, I could have broken files Into many partitions and load them.


Cheers,

Raja



     
  <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: 23 Jun 2019