Main dimension and profile dimension

View previous topic View next topic Go down

Main dimension and profile dimension

Post  Oleole on Wed Feb 15, 2012 10:48 am

Hi !

Is it ok to have a mini dimension and a main dimension without using a factless facttable between them to catch attribute changes occurring outside business/fact events ? Ie include the key for mini dim in the main dim which holds from/to dates.


Oleole

Posts : 12
Join date : 2012-02-15

View user profile

Back to top Go down

Missing / overlook something ?

Post  Oleole on Fri Feb 17, 2012 4:44 am

To clarify, will we be missing/overlook something by doing it this way ?
The volume in the main dimension and mini dimension is not to big, and the frequency of changes in the mini dimension is not high.

Opinions most welcome !

Regards Ole

Oleole

Posts : 12
Join date : 2012-02-15

View user profile

Back to top Go down

Re: Main dimension and profile dimension

Post  hang on Fri Feb 17, 2012 6:58 pm

Oleole wrote:The volume in the main dimension and mini dimension is not to big, and the frequency of changes in the mini dimension is not high.
Then why do you need a mini dimension in first place? The tradeoff for mini dimension is to control the size of big and fast growing main dimension for the price of complicating the relationship by fact table or snowflaked outrigger.

hang

Posts : 528
Join date : 2010-05-07
Location : Brisbane, Australia

View user profile

Back to top Go down

Re: Main dimension and profile dimension

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