All Forums Analytics
woodje 1 post Joined 04/11
12 Aug 2011
Multiple Database connections in a query

Hello,

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.

Thanks,
Jeff

othbel 4 posts Joined 12/09
29 Apr 2012

Hi Jeff,

 

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

 

BR.

Otto

othbel 4 posts Joined 12/09
03 Jun 2012

Hi Jeff,

 

i confirm, Informatica data Integrator do such as task

You must sign in to leave a comment.