Q:

Our consultant is proposing the use of both the star and snowflake schemas in our datamart architecture. Is this a typical practice in the industry? What do we gain and lose by this approach in the long-term? Are we building a hybrid that will marry us to our consultant for any future modifications? In my one week of DW fundamentals training with the DW Institute, there seemed to be a unilateral emphasis on staying only with a star schema.

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