|
|
Portland Chapter
Data Administration Management Association
P.O. Box 2343
Portland, OR 97208-2343
www.dama-pdx.org
Board Members
President
Wayne Little
VP Membership
Krishna Moorthy
VP Education
Open
VP Communication
James Lee
VP Financial Services
Nancy Hallock
VP Online Services
Atul Borkar
VP Secretarial Services
Don Rognlien
Past President
Hanteng Dai
| |
Tuesday, 23th September, 2008 Meeting |
|
Change Data Capture for
Data Warehousing
|
| Presented by Arnoud Otte
Time: Registration/Refreshments - 8:30-9:00 a.m.
Presentation - 9:00-11:00 a.m.
Announcements - 11:00-11:30 a.m.
Change Data Capture
(CDC) - Most RDBMS vendors have a version of it, and most data
warehouse professionals have built it in one form or another. This
presentation will define CDC and its close relative changed data
capture. It explains how the reasons for CDC and the destinations
for the captured changes drive how to best capture change
data. Different pitfalls associated with processing of change
data into the respective destinations are exposed. Attendees will
know when to use which CDC method, how to process the captured
changes into their destinations, and be able to provide a clear
rationale for their choice.
Arnoud
Otte has been active in databases since 1992, moving into
data warehousing in 1995. He has worked for Nike for 11 years, and
is currently working at Regence Blue Cross Blue Shield as a Solution
Engineer.
| |
