Dimension Question

View previous topic View next topic Go down

Dimension Question

Post  davVisitor on Mon Mar 04, 2013 5:55 pm

Suppose that I have a dim_person table and that dim_person lives in a city which belongs to a state.

Should the dim_person table have all of the attributes of city and state in a data warehouse? For example, a column for state and city in the dim_user table. Would this still be true if city and state have a large number of attributes (50+)?

davVisitor

Posts : 3
Join date : 2013-03-04

View user profile

Back to top Go down

Re: Dimension Question

Post  BoxesAndLines on Mon Mar 04, 2013 7:44 pm

There are normally multiple addresses associated with a Person (or Party). Most folks will try to manage the party address via a factless fact table. I also include a geography dimension separate from the address information for a party. It is in the geography dimension where I would maintain a hierarchy and not in the person dimension.
avatar
BoxesAndLines

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

View user profile

Back to top Go down

Re: Dimension Question

Post  hayrabedian on Tue Mar 05, 2013 6:04 am

davVisitor wrote:Suppose that I have a dim_person table and that dim_person lives in a city which belongs to a state.

Should the dim_person table have all of the attributes of city and state in a data warehouse? For example, a column for state and city in the dim_user table. Would this still be true if city and state have a large number of attributes (50+)?

Snowflaking is not an evil. Just create a region dimension (with the city-state-region hierarchy) and reference it from within the dim_person.

hayrabedian

Posts : 7
Join date : 2011-04-01

View user profile

Back to top Go down

Re: Dimension Question

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