Connect two different teradata box and retreive data

Database

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

Re: Connect two different teradata box and retreive data

you could use "linked tables" in an MSAccess database... and perfrom the minus operation inside MSAccess