Zencos will be presenting a series of papers at SAS Global Forum this coming April. Be sure to register and sign up!
One paper will be centered around the change data capture process of building an Enterprise Data Warehouse. Stephen Overton will be presenting this on Monday, April 23 at 3:30pm. The paper number is 112-2012.
The paper is about developing a flexible ETL process to capture data changes efficiently. Data sources integrated into an Enterprise Data Warehouse most likely will have different extraction frequencies as well as different time granularity. One of the key steps in loading a data warehouse is to detect changes in these data sources and keep only the pertinent data. In other words, extract and insert only data that has not already been extracted and inserted. The paper will present a flexible process to extract and load new data during any phase of loading a data warehouse. The process can be run dynamically at any time and requires no set schedule. The paper will also include a SAS program to manage data retention in the warehouse. Both processes are centrally managed and operate independent of each other.
Check out SAS Global Forum here: http://support.sas.com/events/sasglobalforum/2012/index.html