I am designing a star schema with a product dimension. One attribute of a product is not unique to the product itself. However, there is a unique attribute associated with the key combination of product and warehouse. I have three other dimensions besides the product and warehouse. What is the best way to include the attribute that is unique to the product and warehouse combination? The possibilities seem to be:

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