What historical insights does your data warehouse provide to users?

This column is the concluding portion of a two-part column on delivery of historical information in the data warehouse environment. This installment examines a method for designing the data warehouse model that can be employed to satisfy this challenging business requirement. In the first part of this series, we saw that using standard design techniques such as slowly changing dimensions (SCD) type 2 only solves a portion of the business need. SCD 2 does easily provide a method to relate all fact table records to the latest dimension key view. There are alternate design approaches that can be implemented with varying levels of effort that provide the type of flexibility needed for this type of information delivery.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access