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

    Critical Interface error - Join between source datastores...

    user12236189
      Hello all,

      ODI 11.1.1.3

      Database
      BANNER
      ----------------------------------------------------------------------------
      Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
      PL/SQL Release 11.2.0.2.0 - Production
      CORE    11.2.0.2.0      Production
      TNS for Linux: Version 11.2.0.2.0 - Production
      NLSRTL Version 11.2.0.2.0 - 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.
      Thanks,