v
Contents Preface............................................................................................................................. vii
Audience............................................................................................................................... vii
Related Documents..............................................................................................................vii
Customer Support................................................................................................................vii
Review Patch Documentation............................................................................................vii
Oracle Retail Documentation on the Oracle Technology Network...............................vii
Conventions.........................................................................................................................viii
1 Preinstallation Tasks................................................................................................... 1
Implementation Capacity Planning......................................................................................2
Check Database Server Hardware Requirements..............................................................2
Check Database Server Software Requirements.................................................................3
Other Software Requirements for the Data Warehouse....................................................4
Check Client System Requirements.....................................................................................4
Create UNIX User Accounts..................................................................................................4
Create UNIX Directories........................................................................................................4
Alter Directory Ownership and Privileges..........................................................................5
Copy Profiles for RDW User.................................................................................................6
2 Installation Tasks.........................................................................................................7
Establish Data Warehouse Partitioning Strategy................................................................7
Create the RDW Database and Tablespaces........................................................................8
Create the Database as Follows......................................................................................8
Create RDW Tablespaces................................................................................................8
Load RDW Database..............................................................................................................9
Create RDW Schema Owners.........................................................................................9
Create RDW Datamart-level tables...............................................................................9
Set up RDW User Permissions.......................................................................................9
Configure RETL....................................................................................................................10
Data Population.................................................................................................................... 10
Populate Datamart Default Data.................................................................................11
Populate Time Dimension............................................................................................12
Populate Static Dimension Data..................................................................................14
Install Oracle Configuration Manager...............................................................................15
A Appendix: Development Database Schema Implementation ................................ 17
B Appendix: RDW Code Tree .......................................................................................19
C Appendix: Oracle 10g Database Creation Scripts.................................................. 21
D Appendix: Tablespace Creation Scripts.................................................................. 25
E Appendix: Installation Order .................................................................................... 27