Articles & Content


DB2 Warehousing Design Best Practices (H02)

Topic: 2005 NA

Subtopic: DB2 for LUW

DATE: 2005-05-23 (12:30 PM - 01:40 PM)
SPEAKERS: Bill O'Connell (IBM Toronto Lab)

Understanding key requirements and strategies for dealing with data warehouses is critical. Topics include configuring DB2 using balanced configurable units (including rules of thumb) on Regatta class systems, strategies for continuos as well as trickle feed loading (including in the presence of MQTs), configuring both virtual marts and or ODSs in the enterprise data warehouse itself, and finally general do's and don'ts.

EXP. LEVEL: Advanced


Key requirements and strategies

Using Balanced Configurable Units on Regattas

Continuous and Trickle feed (in presence of MQTs)

Virtual Mart and ODS consolidation into an EDW

General Do's and Don'ts

This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.