Need: Join multiple tables from two different oracle DB in same network.
1. New to informtica so wanted to know how it can be done with Informatica
2. Does DB link needs to be created for Informatica to join the table?
3 how does Informatica internally process such cross oracle DB joins - such as does it cache entire table in to memory on informatica server from remote DB? How is the connections made to two DBs
4. each of these table has total 50 Million records, will there be any performance issue?
5. Is there are optimal way to do cross DB join in in Informatica- Powercenter 10.2 version ?
Any help is appreciated
You main loading into new table sourcing from 2 different DB tables?
You need to create connection for those 2 dbs and then import them as 2 soruces using Source transformation and then use Joiner transformation and rest is same with your logic to load target table.