The following describes the functions and usage of the DB2 data warehouse center. If you are interested in the DB2 data warehouse, take a look.
DB2 on Windows and AIX comes with a data warehouse center. This free tool provides a function subset of the data warehouse center belonging to DB2 DWM. The DB2 data warehouse center is free, giving DBAs the opportunity to try some of the powerful features they can use in DB2 DWM.
The data warehouse center provides:
Register and access heterogeneous data sources
Data Extraction and conversion steps
Automated filling of warehouse and warehouse management processes
The DB2 Data Warehouse Center supports all-new and step-by-step data movement options, including leveraging the powerful IBM Integrated Data Replication feature ). The data Warehouse launch board Warehouse Launchpad simplifies the filling of Warehouse jobs by guiding you through related tasks. Describes the process modeling window of the data warehouse center:
The DB2 data warehouse center is a component installed in DB2. If you select this component, the Control database is created to help you manage your data warehouse. DB2 includes a tutorial that guides you step by step to set up and create a data warehouse using this tool. I recommend that you find this tutorial in the First Steps and DB2 Information Centers ).
Remember that the DB2 data warehouse center is also part of the DB2 DWM. In DB2 DWM, it comes with more agents, transformations, functional components, and so on, and is intended for enterprise-wide data warehouses.
Provides you with an in-depth understanding of the DB2 data warehouse.
How to query and create a table using DB2
Introduction to DB2 recursive query
Implementation of DB2 Paging
DB2 cursor and usage