Articles & Content

Archives

Solving Warehouse Source Data Issues Using DB2 on z/OS (A05)

Topic: 2010 NA

Subtopic: DB2 for z/OS



DATE: 2010-5-12 (08:30 AM - 09:30 AM)
SPEAKERS: Robert Goodman (Florida Hospital)

There are many ways to extract warehouse source data on z/OS. The challenge is to get timely, accurate data in consistent referential sets. Do you understand the systemic issues that all warehouse data sourcing solutions face? This session will trace one users' journey from wildly inconsistent warehouse data to a pseudo real-time data extraction model which fully exploits muti-row functions and exercises the power of DB2 on z/OS. Join us as we explore a comprehensive user built solution that addresses warehouse needs in a timely, accurate and cost effective manner. Exploit the power of DB2 on z/OS and make your warehouse woes a thing of the past.

EXP. LEVEL: Beginner,Intermediate,Advanced

OBJECTIVES:

Understand the systemic problems that all data warehouse sourcing systems face.

Examine the spectrum of data extraction solutions and analyze to strengths and weaknesses of each methodology.

Define a new data extraction model that exploits multi-row SQL functions and cross systems connections to efficiently and quickly extract consistent referential sets with no data outages.

Review the refinements and lessons learned in developing and implementing this model and illustrate how this might help you in adjusting your data extraction methodology.

Examine the lessons learned and investigate how this may apply in the pseudo real time data warehouse of the future.



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.