Good Examples of Dimensions?
3 posters
Page 1 of 1
Good Examples of Dimensions?
I am just getting started with this material and I'm looking for some good trustworthy examples.
For example if you have a mail-order company with one location and you have a product dimension and a customer dimension and a date dimension and the fact table contains sales amounts -- what are a few other dimensions that would be logical and correct?
If someone is perhaps interested in analyzing the sales in terms of the gender of the customer or the customer location would you do anything differently in the star schema other than simply having gender and city and state included in the customer dimension table? I am totally confused by examples I have seen where customer characteristics are broken into different dimensions. Why do that? Thanks.
For example if you have a mail-order company with one location and you have a product dimension and a customer dimension and a date dimension and the fact table contains sales amounts -- what are a few other dimensions that would be logical and correct?
If someone is perhaps interested in analyzing the sales in terms of the gender of the customer or the customer location would you do anything differently in the star schema other than simply having gender and city and state included in the customer dimension table? I am totally confused by examples I have seen where customer characteristics are broken into different dimensions. Why do that? Thanks.
davej- Posts : 6
Join date : 2014-02-17
Re: Good Examples of Dimensions?
One reason is performance. If your company is large, say your local telco large, then you have millions of customers. Joining a multi-million row dimension table with a multi-million or billion row fact table can tax the best of databases. Another reason is drill across. If there are some customer demographics with hierarchical aggregations that I'd like to use to drill across multiple fact tables, I can do it easily by breaking those attributes out of the customer dimension.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Re: Good Examples of Dimensions?
So you would duplicate some of the information in the customer table to create these other tables? A customer state/province table? A customer zipcode table? The customer gender becomes a degenerate dimension of the fact table?
davej- Posts : 6
Join date : 2014-02-17
Re: Good Examples of Dimensions?
Generally use degenerate dimensions sparingly, specially attributes that someone may want a description for. Its usually used for stuff like document numbers. Junk dimensions are a better alternative, for example, clustering demographic attributes (age, sex, etc…) into a single small dimension.
Similar topics
» Modeling Descriptive Flex Fields (Attribute Columns) on an Order Line
» Drill Around - Examples, Relevancy
» How to make Quality Assurance and unit tests for a DW/BI project?
» Asset Hierarchy in Transmission Utiltiy
» makeing a stand for star schema design
» Drill Around - Examples, Relevancy
» How to make Quality Assurance and unit tests for a DW/BI project?
» Asset Hierarchy in Transmission Utiltiy
» makeing a stand for star schema design
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum