2 Replies Latest reply on Jul 4, 2012 7:13 AM by 770542

    Critical Interface error - Join between source datastores...

      Hello all,


      Oracle Database 11g Enterprise Edition Release - 64bit Production
      PL/SQL Release - Production
      CORE      Production
      TNS for Linux: Version - Production
      NLSRTL Version - Production
      I am creating an interface which is one target data store but the source tables are from multiple data stores. When I build the join and try to save the interface im getting this following error
      Critical     Join between source datastores DW_ITEM_ST and EMP_MAIN, "DW_ITEM_..."     A join executed on the source cannot join datastores located on different data servers.
      I am joining the tables from the target data store also from source data store, this target table in the source is not a loading thru this interface.

      How do I make a source joining from target datastore and other data stores.

      any help would be greatly appreciated.