fast load performance

Tools
Enthusiast

fast load performance

Loading 350 million records from oracle to teradata takes around 15hrs using informatica fastload connection.
Performance of this need to be increased. Could you please help me on this to reduce the time it takes to load?

Properties used are - checkpoint(1 million)
error limit (500), tenacity(1),max sessions (20),
sleep(3), is_staged,truncate_target

Expecting quick response.
2 REPLIES
Teradata Employee

Re: fast load performance

Hello,

It depends on the requirements. If they are flexible, you can create data file from oracle, and use that as input for Fastload. Next thing to consider is the network. Thirdly, you can try TPT.

HTH.

Regards,

Adeel
Enthusiast

Re: fast load performance

We are using informatica for this.
Could you please give any performance pointsin that aspect?