Mini Dimensions

View previous topic View next topic Go down

Mini Dimensions

Post  tim_goodsell on Thu Sep 23, 2010 7:02 pm

Hi

In out data warehouse design (superannuation) we need to cater for Client and Accounts and the relationship between them (a client can have one or more accounts). Some of the client attributes can change so we were thinking or having a client dimension and also a mini dimension for the changing attributes. Also some of the account attributes can change frequently so we were thinking of having an account dimension and an account mini dimension for the changing attributes. What is the best way to link the client/accounts , a fact table containing client dimension/mini dimension keys and account dimensions/mini dimensions keys with start/end dates ?

Regards

Tim



tim_goodsell

Posts : 49
Join date : 2010-09-21

View user profile

Back to top Go down

Re: Mini Dimensions

Post  BoxesAndLines on Thu Sep 23, 2010 10:22 pm

A fact table is the best method for relating dimensions.
avatar
BoxesAndLines

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

View user profile

Back to top Go down

Re: Mini Dimensions

Post  tim_goodsell on Fri Sep 24, 2010 12:18 am

Thanks for that


Does this mean that I have to create a fact table with each row containing

a FK for the clients mainn dimension
a FK for the accounts main dimension
a FK for the clients mini dimension
a FK for the accounts mini dimension
a start date
an end date

Regards

Tim

tim_goodsell

Posts : 49
Join date : 2010-09-21

View user profile

Back to top Go down

Re: Mini Dimensions

Post  BoxesAndLines on Fri Sep 24, 2010 8:00 am

Yes, it's good practice to keep the mini dimension FK's on the fact instead of just the main ones. Make sure your dates are FK's as well.

avatar
BoxesAndLines

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

View user profile

Back to top Go down

Re: Mini Dimensions

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