0 Replies Latest reply on Jul 23, 2010 4:49 PM by Val Sw

    Mapping column from different schema, table

    Val Sw Expert

      I have User entity which is mapped to users table and this users table use SchemaA (using DatasourceA).


      We need to map User entity to a column say Department which is in Schema B.


      Please suggest best approach.


      desc users
      Name                           Type                                                                                                                                                                                         
      ----                           ----
      HJID                           NUMBER(19)                                                                                                                                                                                   
      EMAIL                          VARCHAR2(255 CHAR)                                                                                                                                                                           
      FIRSTNAME                      VARCHAR2(255 CHAR)                                                                                                                                                                           
      LASTNAME                       VARCHAR2(255 CHAR)                                                                                                                                                                           
      DEPARTMENT                     VARCHAR2(255 CHAR) // THIS SHOULD BE FROM SCHEMA B