Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

joining dimension table to dimension and again fact table

2 posters

Go down

joining dimension table to dimension and again fact table Empty joining dimension table to dimension and again fact table

Post  kuldeepchitrakar Wed Sep 12, 2012 6:15 am

Hi

I am analyzing one DW schema and I came to a situation where dimension table is joined to dimension and fact table. Here are the details.

Fact has joins from PersonDim and LocationDim

PersonDim also has join from LocationDim with LocationDim-PersonDim relationship type as 1-n

Is this a good design as i am seeing it as un-necessary as you can easily get Location level data from PersonDim table if Person and Location dimension table are merged.

What are your thoughts on this

kuldeepchitrakar

Posts : 17
Join date : 2010-04-21
Age : 39
Location : India

http://www.bidwbooks.com

Back to top Go down

joining dimension table to dimension and again fact table Empty Re: joining dimension table to dimension and again fact table

Post  yuldashev Wed Sep 12, 2012 11:54 am

Hi Kuldeep,

The implementation depends on the business definition and complexity of your Person and Location entities. Usually, Person or Employee and Location or Department are different business entities and used separately in different business processes. Sometimes, Employee and Department hierarchies are very complex. In these cases it's recommended to have two different dimensions.
One of the principles I follow when I architect a data warehouse is that business need is more important than technical perfection.

Thanks,
Alisher
www.streebo.com
yuldashev
yuldashev

Posts : 13
Join date : 2012-08-14
Location : Ottawa, Canada

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum