Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 07 Apr 2015 @ 15:28:56 GMT


     
  <Prev Next>   <<First <Prev
Next>
Last>>
 


Subj:   Re: T-PUMP to load from TD Staging to TD Target
 
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, April 07, 2015 09:09 -->

No, TPump reads a file on the client. You can FastExport to a named pipe and have TPump read from the pipe so you don't necessarily have to land the data, but I wouldn't recommend that design for production jobs - too hard to troubleshoot if anything goes wrong. Using TPT, you can combine EXPORT and STREAM operators to read from a table and write back to Teradata in the same job. But you would need to force STREAM (or TPump) to process & commit a single row at a time to meet your other "requirements".

But why insist on this design? Pulling data out of the database to put it back in won't be optimal. What are you trying to solve / achieve and what are the real design goals / constraints?



     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016