Rittman Mead - Delivered Intelligence

In this final posting in the series, I’ll look at how Oracle Warehouse Builder 10.2 can be used to perform Partition Exchange Loading into a target table. Partition Exchange Loading (PEL) s a data warehousing technique that is useful when you are loading data into a large, partitioned table. By swapping the table that contains [...]

In addition to the conventional Select D1,D2,SUM(M1) from base group by D1,D2 type of summary Oracle offers two other approaches: Oracle OLAP cubes and the various extensions to GROUP BY. Oracle OLAP has it roots in the Oracle Express technology – that is the the stand alone OLAP database and not any more recent additions [...]

In one of last week’s postings I looked at how relational data objects are defined using Oracle Warehouse Builder 10gR2. In this posting, I’ll look at how OLAP objects are defined and populated. To define OLAP objects, you don’t need to have installed and licensed the OLAP Option to the Enterprise Edition of the database. [...]

In one of last week’s postings I looked at how relational data objects are defined using Oracle Warehouse Builder 10gR2. In this posting, I’ll look at how OLAP objects are defined and populated. To define OLAP objects, you don’t need to have installed and licensed the OLAP Option to the Enterprise Edition of the database. [...]

Summary tables are often very suitable candidates for partitioning. They are usually date organised and as we generally receive data for a limited range of dates we are able to apply the changes to a subset of partitions of a table. In particular we can get away from the use of merge or delete/insert type [...]