Newbie - Star Schema Advice

View previous topic View next topic Go down

Newbie - Star Schema Advice

Post  arfan on Fri Dec 02, 2011 1:49 am

I need help fitting my last dimension into a classic star schema Im designing. The business use is for vendors to submit product information to various businesses.

My fact table is submissions that is connected to various dimensions (vendor, business, products, manufacturer, etc.)

My question surrounds a dimension called product_questions. I need this dimension because each business can define what questions they want a vendor to answer about a product before it is submitted to their company. Im trying to avoid adding a column for each new question a business wants to ask in this table but as a newbie Im not seeing any other way to capture this data. I know I'm missing something simple and Im hoping you can point me in the right direction. Is there something in the snowflake schema that addresses this?

Thanks in advance.



arfan

Posts : 1
Join date : 2011-12-02

View user profile

Back to top Go down

Re: Newbie - Star Schema Advice

Post  BoxesAndLines on Fri Dec 02, 2011 10:23 am

It almost sounds like another fact table. The other option is to build a bridge table to handle the lower level grain of the product question dimension.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum