|
Let's assume that as an organization, you are having wide variety of products,
ranging from very simple products (needing say 5 attributes) to complex products
(needing 50 attributes). If you are selling mostly simple products (say 90%
by volume), the product dimension table will be a sparse table, with most
of the cells as Null. As long as you have a variable field database (like
Oracle), it's OK. However for a fixed field database, you will need to have
a way to reduce the storage space over-head. The best way to handle it is
to have snow-flake whereby the common fields (which are populated for simple
as well as the complex products) are in the main dimension table and the ones which are specific to the complex products are in the snow-flake table linked to the main dimensional table. |
