All Forums Tools
rlaskar 18 posts Joined 03/06
14 Jun 2007
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_AminusSelect column A from TEST.TABLE_AThanks,rlaskar

joedsilva 505 posts Joined 07/05
14 Jun 2007

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

You must sign in to leave a comment.