Newbie - Star Schema Advice
2 posters
Page 1 of 1
Newbie - Star Schema Advice
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.
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
Re: Newbie - Star Schema Advice
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.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Similar topics
» Star Schema vs All in one table
» Advice on schema. Is the table in question dimensional or factual?
» star schema designing
» Help designing star schema
» Star Schema for Surgeries
» Advice on schema. Is the table in question dimensional or factual?
» star schema designing
» Help designing star schema
» Star Schema for Surgeries
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum