Conformed Fields or Snowflake? - Shop and Customer Location

View previous topic View next topic Go down

Conformed Fields or Snowflake? - Shop and Customer Location

Post  rendybjunior on Wed Nov 05, 2014 2:19 am

I have shop dimension and customer dimension which both has location information.

Should I create location dimension to correlate shop location and customer location?
I believe this one is called snowflake schema. I heard that it is hard to maintain.

Code:
  |----------| |---------| |----------|
  | Dim_Cust | ----- | Dim_Loc | ----- | Dim_Shop |
  |----------| |---------| |----------|


Or, should I maintain definition that shop and customer dimension is conformed by each location field?
For this one, I denormalized location information to each dimension.

Code:
  |----------| |----------|
  | Dim_Cust |------ | Dim_Shop |
  |----------| |----------|

rendybjunior

Posts : 7
Join date : 2014-09-30

View user profile

Back to top Go down

Re: Conformed Fields or Snowflake? - Shop and Customer Location

Post  Dr. Warehouse on Wed Nov 19, 2014 6:18 pm

Maybe you could explain a bit about what you are trying to achieve? What are you measuring? How do you want to model your fact table? That usually has a big impact on what the correct solution to your problem is.

Snowflaking should generally be avoided. Your second example still resembles part of a snowflake (dim to dim) though.

Dr. Warehouse

Posts : 5
Join date : 2014-10-28

View user profile

Back to top Go down

Re: Conformed Fields or Snowflake? - Shop and Customer Location

Post  ngalemmo on Wed Nov 19, 2014 6:49 pm

What do you mean by 'location'? Is it some form of geo-coding (lat/long, region code)?

The location needs to remain in context. One is the presumed location of the customer and the other the location of the store. Location itself doesn't necessarily require its own dimension. You only consider a dimension if the entity itself has attributes. If it is just a code and description those are usually maintained within the customer and store dimensions.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Conformed Fields or Snowflake? - Shop and Customer Location

Post  Sponsored content


Sponsored content


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