3 Replies Latest reply on May 15, 2019 7:06 AM by Nico Heinze

    Read table from one database and create materialized view in another database

    bhavani sankavaram New Member

      Hi all,


      I have a requirement to read table from one DB and create MV on this table in another DB. The definition of MV is simple and is something like this


      Create materialized view tab1_mv as SELECT * from tab1; However, tab1 is in DataBase1 and tab1_mv should be created in DataBase2.


      I tried using SQL Transformation but it allows only one logical connection, but in this case i need two connections (one to read table and another to create MV)


      I am using Informatica PowerCenter 10.2 HF1 on Linux 7.2


      Any ideas on how to achieve this is much appreciated?