Teradata PT provides a way to load data directly and quickly from table in one Teradata server to table in other Teradata server.

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]);
);