Business Intelligence Files
There are several errors present in many data warehouse implementation on Oracle. Central to these is the lack of effective use of partitioning. Partitioning is crucial and particularly well-suited to the requirements large data warehouses, but how do you use this complex functionality effectively? It is important to understand what other major features of Oracle partitioning enables, and how and why? This presentation is the result of LONG practical experience in logical and physical database design for data warehouses, driven by the combination of business requirements and systems requirements and painfully-gained understandings of data warehousing realities. It will provide straight answers to utilize Oracle's features, particularly partitioning, to ensure a successful data warehouse implementation.