Exporting around 3 TB of data from Teradata

General
Enthusiast

Exporting around 3 TB of data from Teradata

Hi all,

I want to Export 3 TB of data from Teradata in flat file or in other format. Please help me with the best resolution for the same. We tried using Fast Export but it takes longer time. Please share your views along with the time estimate for Exporting 3 TB of data.

Tags (1)
4 REPLIES
Enthusiast

Re: Exporting around 3 TB of data from Teradata

Have you tried TPT export? This would enhance the performance of exporting huge data compared to standalone Fexport script.

You would be able to deffine multiple instances based on your system config in TPT Export script and maximize the performance. Each instance in turn has its own number of sessions leveraging Teradata parallelism.

Can't give you time exstimation for this activity as it depends on many factors such as your system config, instances/sessions defined in script, network parameters.

Enthusiast

Re: Exporting around 3 TB of data from Teradata

Hi Dhiraj,

I have tried using TPT Export and have produced 10 files of around 12 GB each by passing the date ranges.

Let me know if you have any better approach than this.

Regards,

Amit 

Enthusiast

Re: Exporting around 3 TB of data from Teradata

Hi Amit,

How about increasing to the maximum sessions? Also you can contact the DBA how he allocates the utilities(mload, fastload....) , session management.

Thanks and regards,

Raja

Enthusiast

Re: Exporting around 3 TB of data from Teradata

Amit, Since Data volume  is high  i can suggest you  to work wih your DBA and export it to a Tape drive. It may take approximately 5 hours on a multi node parallel processing system. Speed completely depends upon your system architecture.

Thanks,

Krishna