Articles & Content
Topic: 2007 NA
Subtopic: DB2 for LUW
DATE: 2007-5-9 (01:40 PM - 02:40 PM)
SPEAKERS: Sriram Srinivasan (IBM)
This talk will introduce the DB2 Data Warehouse edition with an overview of the architecture. The main emphasis will be on the tools available for DB2 UDB Warehouse building and maintenance, especially to perform in-database transformations. DWE Design Studio is an eclipse based product that enables users to model or reverse engineer database schema as well as to model data warehouse processing using Data and Control flows. The framework also provides a way to integrate external scripts or jobs in ETL engines such as DataStage.
EXP. LEVEL: Beginner,Intermediate
How to build in-database transformations to maintain DB2 UDB warehouses
Test execute and debug processes from the eclipse based Design Studio
Deploy to a production environment
Quick examples on how to integrate SQL-based warehousing processes and Data Stage ETL Jobs
Manage warehouse processes using the DWE Admin
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!Click to Download
NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.