1 Reply Latest reply on Dec 7, 2018 8:36 AM by Srini Veeravalli

    Join multiple tables in two different oracle DB

    Hemant Chavan New Member

      Need: Join multiple tables from two different oracle DB in same network.


      Ques -

      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