Todd Schraml is senior data architect and manager of ETL for Innovative Health Strategies. He can be reached at tschraml@ihsiq.com.

The Us-Versus-Them Dynamic
July 1, 2007 Beyond simple security concerns that naturally arise with any work performed outside the corporate firewall, offshore...

Updating Slowly Changing Dimensions
April 19, 2002 Updating slowly changing dimensions encompasses a complex array of processing threads. This article takes a look at three...

Hidden Complexities in a Simple Star Schema
March 8, 2002 The star schema intentionally creates a simplified data arrangement that aids users in understanding the design while...

Retyping Slowly Changing Dimensions
May 26, 2000 Citing Ralph Kimball’s theory on multidimension design, the author discusses how to handle slowly changing dimensions within a...