Q: In a star schema can there be eight fact tables? If there can be eight fact tables, what happens if you want to join data from two fact tables? Can you send an example of a schema with two or more fact tables and an example of a join between the fact tables?

It is rare to have a single star schema with eight fact tables. However, it is quite common to have eight star schemas with each fact table sharing some of the same conformed dimensions. In order to join two or more fact tables together, there must be at least one common dimension between the fact tables.

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