I am pulling data from an oracle 11g database. And would like to connect to our teradata data warehouse to enrich this data. I am using Toad for Analytics and have connections setup and can run queries seperatly from the two databases. However I want to Inner join the two in one query. Can this be done? If so can you direct me to some examples so I can learn how to accomplish this.
I don't have an magic solution, but i recommand you to check INFORMATICA Data Integrator , or use Editors wich allows multipple connection in the same sessions, but i insest that Informatica is able to achiev such as task