Connect two different teradata box and retreive data

Database
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

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