Branch dimension

View previous topic View next topic Go down

Branch dimension

Post  remiby on Thu Jun 27, 2013 8:53 am

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?

remiby

Posts : 19
Join date : 2012-04-10
Location : Paris, France

View user profile http://www.horus-df.com/

Back to top Go down

Re: Branch dimension

Post  ngalemmo on Thu Jun 27, 2013 12:45 pm

Why isn't branch a dimension off the fact?
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: Branch dimension

Post  BoxesAndLines on Fri Jun 28, 2013 8:54 am

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.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

Re: Branch dimension

Post  sgudavalli on Sat Jun 29, 2013 12:21 pm

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 : 32
Location : Pune, India

View user profile

Back to top Go down

Re: Branch 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