Oracle Audio Technologies Retail Data Warehouse 13 - Manual (Page 25)

Database Installation Guide 17
A
Appendix: Development Database Schema
Implementation
The following figure shows the source system and RDW development schemas that are
referred to in this installation guide.
Source Database
(Dimension Data, Fact
Data, etc)
Source Server
(i.e. RMS, ReIM, etc.)
Oracle Database
RDW 13.0 Development Environment
Target Server
RDW 13.0
Oracle Database
Flat File Landing Directory
RDW USERS:
RDW13DM - Owns datamart level (_DM
tables)
RDW13DEV -- Batch user to execute
RDW modules.
RDW13SYS– OBI EE User that connects
to the metadata and the warehouse.
RDW13DM
RDW13DEV RDW13SYS
Flat Files
Facts, Dimensions
and Interfaces
(RESA, MFP, etc.)