Branch dimension
4 posters
Page 1 of 1
Branch dimension
I have many dimensions (employee, client, deposit, loan...) linked to a Branch dimension.
Should I snowflake putting a branch_key in each dimension (snowflake) or should I create factless fact tables for each relation?
Last option would be to put only few attributes of my branch dim in each dimension to avoid snowflaking.
What do you think?
Should I snowflake putting a branch_key in each dimension (snowflake) or should I create factless fact tables for each relation?
Last option would be to put only few attributes of my branch dim in each dimension to avoid snowflaking.
What do you think?
Re: Branch dimension
I wouldn't copy all the branch attributes to the other dimensions. I would try to manage the branch relationships through the fact table. If I had reporting the only used dimensions (all employees in a branch), I would just keep the snowflakes.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Re: Branch dimension
remiby wrote:I have many dimensions (employee, client, deposit, loan...) linked to a Branch dimension.
Should I snowflake putting a branch_key in each dimension (snowflake) or should I create factless fact tables for each relation?
Last option would be to put only few attributes of my branch dim in each dimension to avoid snowflaking.
What do you think?
When you say you got dimensions (employee, client, deposit and loan ... ) linked to a Branch dimension..
Lets say an Employee made a deposit....
1. the employee can be from branch X..
2. the loan can be taken from branch Y
3. the deposit might have done at branch Z
4. the client might be from Branch A
Simplest solution is to add four more dimensional keys to fact table (employeebranch, clientbranch, depositbranch, loanbranch ...)
and create a simple star schema and it makes everyone's life easy.
If all you need is a branch name; i would say go ahead and add it to individual dimension table. As it avoids creating seperate dimension table and extra dimensional keys to fact table..
sgudavalli- Posts : 29
Join date : 2010-06-10
Age : 39
Location : Pune, India
Similar topics
» bridge table and junk dimension on customer dimension (bank/credit union)
» Modeling an Employee Dimension to a Fact which has two columns relating to the Dimension
» How to handle a Type I or II dimension with a snowflaked customer sub dimension (kimball book page 337, 338)
» modelling Product dimension for Pizza outlet
» Using the Date Dimension for Summary Fact Tables or new specialized Month Dimension?
» Modeling an Employee Dimension to a Fact which has two columns relating to the Dimension
» How to handle a Type I or II dimension with a snowflaked customer sub dimension (kimball book page 337, 338)
» modelling Product dimension for Pizza outlet
» Using the Date Dimension for Summary Fact Tables or new specialized Month Dimension?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|