Mini Dimensions

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

A fact table is the best method for relating dimensions.

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

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.