What table key method do you use in your dimensional models?

One of the first data modeling decisions a data warehouse data architect and project manager will make is deciding what type of key fields to use in a dimensional model. This decision centers on whether to use the production key fields from the source systems, sometimes referred to as the natural keys, or to incorporate the use of surrogate keys as an alternative. While this decision may at first seem relatively trivial, it has a significant impact on the methods and tools that will be used for maintenance and information delivery with the data warehouse.

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