The DB2 Warehouse Manager is a separately priced feature that enhances the scalability, manageability, and accessibility of your DB2 warehouse. The Data Warehouse Center supports full refresh and incremental update data movement options including leveraging the power of IBM's integrated data replication functions and the Warehouse Launchpad simplifies the job of populating a warehouse by leading you through the related tasks. Programming Examples Instructions and example programs have been provided on using the Data Warehouse Center. How to automate data mining runs using Intelligent Miner in the Data Warehouse Center environment. How to schedule the Data Warehouse Center to collect information from an MQ Series queue How to access OLE DB sources in Data Warehouse Integrated SQL Assist Functionality Integrated SQL Assist capabilities help customers define over 100 transformations using the rich SQL available with DB2.
Users can also build customer transformation routines using the Stored Procedure Builder.
Star Schema Builder Within the Data Warehouse Center, the Warehouse Schema Modeler is a specialized tool for generating and storing schema associated with a data warehouse. Any schema resulting from this process can be passed easily as metadata to an OLAP tool. The Process Modeler allows user to graphically link the steps needed to build and maintain data warehouses and dependent data marts. Dependency relationships, conditional processing, and notification can all be included in the model. Processes can be scheduled for one-time or repeating execution, or triggered by internal or external processes.