Account Type
2 posters
Page 1 of 1
Account Type
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
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
Re: Account Type
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.

» Type-2 Dates as Date Data Type ?
» Calculated measure value in aggregate fact table
» rationale behind dimension with Type 0 and missing Type 5
» Why do I need type 3 and 6 SCDs when I can implement type 7?
» Type 2 dimension or type 2 column?
» Calculated measure value in aggregate fact table
» rationale behind dimension with Type 0 and missing Type 5
» Why do I need type 3 and 6 SCDs when I can implement type 7?
» Type 2 dimension or type 2 column?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|