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.
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.
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.
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,
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.