Articles & Content

Archives

DB2 DWE: Warehouse Building Infrastructure (I10)

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

OBJECTIVES:

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!

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.