Hi,
We have a STAGING AREA (DB) that will source the data from 2 different source systems in 2 different tables. In this case, please advise.
1. if we create a Data Server pointing to this Staging Area DB and 1 Physical and Logical Schema would it suffice? or we have to create 2 Data Servers, Physical schemas?
2. Can we use a single context GLOBAL --> pointing to the Logical Schema or we need to have 2 Contexts separately pointing to their respective Logical Schemas?
Thanks,
SSP