Teradata PT (TPT) provides a way to load data directly and quickly from table in one Teradata server to table in other Teradata server. There is no need to create a file and load. This can be accomplished using TPT's Export and Load operators.
DEFINE JOB Teradata_To_Teradata DESCRIPTION 'Load from Teradata table to other table in other server' ( DEFINE SCHEMA td_td_schema ( emp_no INTEGER, ename_name VARCHAR(50), hire_date ANSIDATE ); DEFINE OPERATOR produce_data TYPE EXPORT SCHEMA td_td_schema ATTRIBUTES( VARCHAR TdPid='TDServer', VARCHAR UserName='tutorial_user', VARCHAR UserPassWord='tutorial_password', VARCHAR SelectStmt = 'select * from emp_formatted;', VARCHAR DateForm = 'ANSIDATE', VARCHAR PrivateLogName = 'exporter_log', INTEGER MaxSessions=6 ); DEFINE OPERATOR consume_date TYPE LOAD SCHEMA td_td_schema ATTRIBUTES( VARCHAR TdPid='TDServer', VARCHAR UserName='tutorial_user', VARCHAR UserPassWord='tutorial_password', VARCHAR TargetTable='emp_td_td_test', VARCHAR LogTable='dept_tpt_stream_log', VARCHAR DateForm='AnsiDate', VARCHAR PrivateLogName = 'loader_log', INTEGER MaxSessions=6 ); APPLY('INSERT INTO tutorial_db.emp_td_td_test VALUES(:emp_no, :ename_name, :hire_date )') TO OPERATOR(consume_date[1]) SELECT * FROM OPERATOR(produce_data[2]); );