Account Type

View previous topic View next topic Go down

Account Type

Post  tim_goodsell on Tue Feb 07, 2012 8:08 pm

Hello

My warehouse will have an Account dimension with one of its attributes being Account Type

The An accounts Account Type can be either A, B, C. However the Account Type can be part of a group and a parent group

Parent Group Group Account Type
X R A
Y S B
Z T C

Is it best to have a snowflake where you have an account type dimension (containing the parent group, group and account type) and have an account type key in the account dimension or is it better to flatten everyting into the account dimension

Regards

Tim



tim_goodsell

Posts : 49
Join date : 2010-09-21

View user profile

Back to top Go down

Re: Account Type

Post  ngalemmo on Tue Feb 07, 2012 10:23 pm

Just flatten it into the account dimension. Don't snowflake. If you would rather have an account type dimension, you can put an FK in the account dimension, but use it only during ETL to populate the account type FK in the fact table. Do not use it to access the account type dimension during a query.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

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