Archives of the TeradataForum
Message Posted: Tue, 07 Apr 2015 @ 15:28:56 GMT
| 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?