iv
3.5.3.1
Collect Statistics as a Prerequisite ........................................................................... 3-10
3.5.3.2
LEFT OUTER JOIN Issue ......................................................................................... 3-10
3.5.3.3
Group By Versus Distinct......................................................................................... 3-12
3.5.3.4
Pruning of Mappings and Tables............................................................................ 3-12
3.5.3.5
Loader Configurations.............................................................................................. 3-12
3.5.3.5.1
Tpump.................................................................................................................. 3-12
3.5.3.5.2
Fastload................................................................................................................ 3-13
3.6
Oracle-Specific Database Guidelines for Oracle Business Analytics Warehouse........... 3-14
3.7
Additional Suggestions for Optimizing Oracle Database Performance in Oracle Business
Analytics Warehouse.............................................................................................................. 3-14
3.8
Partitioning Guidelines For Large Fact Tables .................................................................... 3-15
3.8.1
Introduction to Partitioning Large Fact Tables ............................................................ 3-15
3.8.2
Partitioning Large Fact Tables ........................................................................................ 3-16
3.8.3
Configuring DAC to Support Partitioned Tables ........................................................ 3-20
3.8.3.1
Creating Source System Parameters in DAC to Support Partitioned Tables ... 3-20
3.8.3.2
Creating Index Actions in DAC............................................................................... 3-22
3.8.3.2.1
How to Create the Index Action to Disable the Local Index Parameter .... 3-22
3.8.3.2.2
How to Create the Index Action to Enable the Local Index Parameter ..... 3-24
3.8.3.2.3
How to Create the Index Action to Enable the Local Sub-Partitioned Index
Parameter............................................................................................................ 3-25
3.8.3.2.4
How to Create the Index Action to Create the Local Bitmap Index
Parameter............................................................................................................. 3-26
3.8.3.2.5
How to Create the Index Action to Create the Local B-Tree Index
Parameter............................................................................................................. 3-27
3.8.3.2.6
How to Create the Index Action to Create the Global Unique Index
Parameter............................................................................................................. 3-28
3.8.3.3
Creating Table Actions in DAC............................................................................... 3-29
3.8.3.3.1
How to Create a Table Action to Gather Statistics on a Partitioned Table 3-29
3.8.3.3.2
How to Create a Table Action to Gather Statistics on a Partitioned Table for
Composite Partitioning .................................................................................... 3-30
3.8.3.4
Assigning Index Actions to Indexes in DAC......................................................... 3-31
3.8.3.5
Assigning Table Actions to Tables in DAC ........................................................... 3-32
3.9
Miscellaneous Information About Oracle BI Applications Deployments ....................... 3-32
3.9.1
Preconfigured Mapping for the SA System Subject Area........................................... 3-32
3.9.2
Using Initialization Blocks............................................................................................... 3-34
3.9.3
Creating Custom Indexes in Siebel Source Databases for Incremental Load
Performance...................................................................................................................... 3-34
3.9.3.1
An Example of Change Capture SQL and Required Indexes ............................. 3-35
3.9.4
Creating Custom Indexes in Oracle EBS Source Databases for Incremental Load
Performance...................................................................................................................... 3-35
3.9.4.1
Creating Indexes for Category 1 Tables ................................................................. 3-35
3.9.4.2
Creating Indexes for Category 2 Tables ................................................................. 3-37
3.9.5
Running an ETL with a Non-English OLTP Data Source........................................... 3-38
4
Installing and Setting Up Oracle BI Applications
4.1
About Oracle BI Applications Topologies............................................................................... 4-2
4.1.1
Summary of Oracle Home Locations Used in this Guide.............................................. 4-3
4.2
High-Level Installation and Setup Task List........................................................................... 4-4