Connect two different teradata box and retreive data

Tools & Utilities
Highlighted
Enthusiast

Connect two different teradata box and retreive data

Hi,

I was trying to figure out how to retrieve data from two different teradata boxes. For example, one table (A) is in development database and the same table (A) is in test database.

I need to do simple query in both the databases like
Select column A from DEVELOPMENT.TABLE_A
minus
Select column A from TEST.TABLE_A

Thanks,
rlaskar
1 REPLY
Enthusiast

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).