Re: Connect two different teradata box and retreive data
The short answer is that you can't do a query across two TD servers.
Now the long answer is, I have seen folks using MS-Access kind of utilities to do that sort of thing, but mind that these utilities in fact retrieve and buffer the data internally to do joins and such queries. So is actually mimicking the functionality. Needless to say it works for small master data kind of tasks. And will be a global disaster for large tables. (And some times they keep locks on the table, making a bad idea to a worse one).