|
|
Archives of the TeradataForum
Message Posted: Fri, 10 Feb 2006 @ 14:53:29 GMT
Subj: | | Re: Dblink in Teradata |
|
From: | | Victor Sokovin |
| Whilst it doesn't answer your specific question, Victor, there is of course TSET for testing the performance of the query - but you
probably knew that anyway. | |
David, I did not post the question; I just tried to answer it.
| Personally, however, I don't use TSET because it seems to take an age to migrate the production stats from Prod to Test. | |
Yes, and it does not help with tests involving data transformations etc.
| In terms of equivalent to 'DB link' I'd be interested in the answer myself. | |
As I said, I'm pretty sure there is none. Some folks play with all kinds of ODBC pipelines but they are just a masqueraded way of importing and
exporting data. Could perhaps help to those who are not familiar with TD utilities and do not have much data to transfer. An example would be,
say, linked tables in Access with data transfer via the PC where Access is installed. Quite easy for a quick ad hoc test.
Victor
| |