Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

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


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.



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