customer and accounts

View previous topic View next topic Go down

customer and accounts

Post  tim_goodsell on Thu Dec 01, 2011 11:52 pm

Hi

I have two dimensions, Customer and account if an account can only have one customer is it better to put the customer key in the account dimension or have a customer/account fact table

Regards

Tim

tim_goodsell

Posts : 49
Join date : 2010-09-21

View user profile

Back to top Go down

Re: customer and accounts

Post  BoxesAndLines on Fri Dec 02, 2011 1:13 pm

Since these are two different things (entities), I would separate them. The only caveat is if "account" is just a synonym for "customer".
avatar
BoxesAndLines

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

View user profile

Back to top Go down

Re: customer and accounts

Post  Jeff Smith on Tue Dec 06, 2011 3:33 pm

I would keep them seperate.

Let's say you to create a Customer level aggregate. If you combine Customer and Account in one dimension, you would have to create a mini-dimension for customer and a view of the customer key and other relevant data from the account table. If the dimension table is big, creating a Customer view from the account dimension can be slow.

Jeff Smith

Posts : 471
Join date : 2009-02-03

View user profile

Back to top Go down

Re: customer and accounts

Post  umutiscan on Mon Dec 12, 2011 2:34 pm

If an account belongs to only one customer, putting the customer key in account dimension is enough.

But be careful if your customer key is a surrogate key. If any change occurs in customer record, you create a new customer sk and you have to reflect this change to the account dimension table. You have to insert a new record, because of the SK change.

umutiscan

Posts : 51
Join date : 2010-11-26
Age : 36
Location : Istanbul, Turkey

View user profile

Back to top Go down

Re: customer and accounts

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