History requirements need to be addressed when designing reporting systems.

For example, if Bob, our customer, moves five times in the last year, we can choose to capture only the most current information where Bob lives today, which is known as a Type 1 slowly changing dimension. Or we can store all history and, therefore, all of Bob's address changes, which is known as a Type 2 SCD. Or we can store some of the history, such as Bob's original or previous address, which is known as a Type 3 SCD. Type 3 is frequently chosen for purely technological reasons, such as simplifying development, saving storage space or increasing query performance. Is the decision to store some history (Type 3) over all history (Type 2) ever driven by business needs, or is it always dictated by technology? In other words, what business reasons are there for modeling a Type 3?

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