 |
 |
Archives of the TeradataForum
Message Posted: Tue, 07 Nov 2006 @ 19:29:18 GMT
| Subj: | | Re: Data extract from Teradata |
| |
| From: | | Stover, Terry |
Responding indicates that the session is returning rows to the client. If you have DBQL logging enabled, the starttime is when the query was
submitted, firstresptime is when Teradata first starts sending rows to the client and lastresptime is when the last row is sent.
In the past I had to move a 10Gig table to SQL server at the end of each month. We found it was 5-10x faster doing a fast export (in 2 Gig
chunks), tar, gzip and ftp. You are probably hung up on network bandwidth and latency (out of Teradata, into Informatica Server, Out of
Informatica Server, into Unix server).
| |
