Td Load sample script :


SelectStmt                 = 'dbname.tablename’,
SourceTdpId                = '',
SourceUserName             = '',
SourceUserPassword         = ‘’
TargetTable                = ‘dbname.tablename’,
TargetTdpId                = '',
TargetUserName             = '',
TargetUserPassword         = ‘’


Tdload –j <filename> to execute