Oracle Audio Technologies Retail Data Warehouse 13 User Manual

 

Database Installation Guide 19 

The following table describes the contents of each of the RDW code tree directories 
created during the RDW installation.   

<base_directory> 

dbasql 

This directory contains all SQL scripts necessary to 
maintain the permissions for the database users.  

<base_directory> 

batch 

Empty directory used for development and testing 
purposes only.   

<base_directory> 

data 

This directory contains the text files that serve as the 
input to RDW RETL load modules.  For clients with 
Oracle Retail applications such as RMS, ReIM, etc, these 
text files can be generated in these source applications.  
The text files should be FTP from the source application 
to the RDW data directory. Directory is empty on 
installation.   

<base_directory> 

error 

This directory holds all program error files, and status 
files.  Directory is empty on installation.   

<base_directory> 

install 

This directory contains all RETL modules and SQL scripts 
needed only at installation. 

<base_directory> 

log 

This directory holds log files of program execution.  
Directory is empty on installation.   

<base_directory> 

rfx 

This directory contains subdirectories for all the code and 
files related directly to RETL  

<base_directory>/rfx bookmark 

This directory contains a file created during execution of 
each module to track the execution of the module.  Files 
are deleted upon successful completion of module.  
Directory is empty on installation.   

<base_directory>/rfx 

etc 

This directory contains files that hold variables used by 
RDW batch modules.  The configuration file is found in 
this directory. 

<base_directory>/rfx 

include 

This directory contains files that hold string language 
translations used by RDW batch modules. 

<base_directory>/rfx lib 

This 

directory contains all RDW library code  

<base_directory>/rfx schema  This directory contains all RDW schema files used with 

each module. 

<base_directory>/rfx 

src 

This directory contains RDW source code. 

<base_directory> 

Metadata 

Contains OBIEE metadata used for middle tier 
installation.