All Forums Tools
S_GALILEO 8 posts Joined 12/15
10 Feb 2016
Very large table loading fails with Fastload, what are other possible solutions?

Dear Experts, 
I have a lrage table (about 200 Go) that I want to load in Teradata. Unfortunately, I am running on a Windows 32 bits machine and hence I get the following error while trying to load the file with the Fastload utility: "Empty file on read open". Is there any workaround with which I can load the file in one shot? Since the file is very big, splitting it to many chunks and loading each chunk with one piece of fastload script is just impossible... Can the TPT work with such a huge file? If yes, could you please give me a hint about how to write the fastload script using the TPT utility? 
Regards. 
 

Ivyuan 63 posts Joined 01/10
15 Feb 2016

Hi,
Please install DataConnector 15.00.00.02 or 14.10.00.08 Efixes or later versions to resolve "empty file on read open" error for large files on Windows platform.
Thanks!

BToddPull 1 post Joined 04/15
17 Mar 2016

Where do you find the download for the DataConnector 15.00.00.02?

Ivyuan 63 posts Joined 01/10
21 Mar 2016

Here is the link to the patch server:
http://tssprod.teradata.com:8080/TSFS/

feinholz 1234 posts Joined 05/08
21 Mar 2016

TPT can actually support having multiple processes read from single, large file and the performance would probably be better than what you can accomplish via FastLoad.
 

--SteveF

You must sign in to leave a comment.