Data Warehousing Articles

(See also: BI & Data Warehousing Topic)

Getting Started with Information Integration [September 2011]
by Jason Williamson, Tom Laszewski, and Prakash Nauduri
An excerpt from Oracle Information Integration, Migration, and Consolidation

Replicating Transactions Between Microsoft SQL Server and Oracle Database Using Oracle GoldenGate [Aug. 2011]
by Nikolay Manchev
Build a simple transaction replication example that spans these platforms, step by step.

Advanced Dimensional Design with Oracle Warehouse Builder [Apr. 2011]
by Yuli Vasiliev
Learn how to go beyond the wizards to build dimensional objects.

Cube Development for Beginners [Apr. 2011]
by Yuli Vasiliev
Get the basics of data warehouse development using Oracle Warehouse Builder 11g.

Preprocess External Tables [March 2011]
by Arup Nanda
Use inline preprocessing on external tables to simplify extract, transform, and load operations.

Using Oracle Database 11g Release 2 Result Cache in an Oracle RAC Environment [January 2011]
by Murali Vallath
Learn about the advantages of this feature for databases in which your data does not change very frequently, such as in a data warehouse or reporting database environment.

Quickly Define KPIs and Scorecards That Use Them [January 2011]
by Mark Rittman
Build key performance indicators and scorecards in your business intelligence metadata with Oracle Business Intelligence Enterprise Edition 11g.

Using the JDBC Connectivity Layer in Oracle Warehouse Builder  [October 2010]
by Yuli Vasiliev
Learn how to use the JDBC connectivity layer in Oracle Warehouse Builder 11g Release 2 to manipulate data in JDBC-accessible sources.

Using the Building on Storage [31-Aug-2010]
by Arup Nanda
Create sophisticated, feature-rich clustered file systems on Oracle Automatic Storage Management disk groups. 

Using the R Package for Oracle Data Mining [July 2010]
by Casimir Saternos
A primer on using the open-source R statistical analysis language with Oracle Database Enterprise Edition.

A Refreshing Move [01-June-2009]
by Arup Nanda
Encrypt, compress, mask, and deliver information with Oracle Data Pump.

Accelerating Data Warehousing [01-May-2008]
by Dan Vlamis
Oracle OLAP 11g brings high-performance data warehouse features to Oracle Database 11g.

Intelligence and Identity [01-Jan-2008]
by Mark Rittman and Joel Crisp
Integrating Oracle Business Intelligence and Oracle Identity Management.

Reporting with the Familiar [21-June-2007]
by Mark Rittman
Create reports with familiar desktop tools and Oracle enterprise datasources.

Building a Hybrid Data Warehouse Model [9-Apr-2007]
by James Madison
As suggested by this reference implementation, in some cases blending the relational and dimensional models may be the right approach to data warehouse design.

Managing Data Quality [26-Oct-2006]
by Ron Hardman
Oracle Warehouse Builder 10g handles the truth.