Please offer your opinion on data movement across Teradata servers( for e.g. production to Test, TD 14 to TD 12/13 or vice versa) using TTU. If you have to rank the tool/technology from the following in terms of performance and Price how would you -
1> Archive/Restore through ARCMain
3> FAST export/Fast load
Thanks for the response. If possible can you please tell the reason why TPT is fastest on the performace than others.
If the requirements permit it, I usually move data from a backup between systems. There are usually faster connections to your backup media and the source system is not effected by a Fast Export. I may be misunderstanding, but I believe TPT would still need to perform a Fast export/Fast load if moving data from one cabinet to another.