Search code examples
informatica-powercenter

Pull from multiple databases in the same source qualifier?

I'm wondering if it is possible to pull from more that one database in the same source qualifier. You can only specify a single database connection per Source Qualifier so I'm not sure if this is possible.

Solution

  • Ben,

    If they are both from the same database vendor and db links are set up, you can use DBLINKS in the source qualifier.

    select a.col1,
       b.col2
  from schema1.table1 a,
       schema1.table2@db2 b
  where a.col3 = b.col4;

    But if they are heterogeneous databases, I think the best way to implement would be create two different source qualifiers (or different look ups based on your requirement and the number of columns) and use the parameter file / session to mention different connections.