Dimensions question
Page 1 of 1
Dimensions question
I'm working on my first Data warehouse project. I'm starting with the basic, identifying business requirements/business processes, initial bus matrix and proritizing my business requirements. That's on itself is hard to identify, however, it seems that I have a good start. For the bus matrix I'm trying to figure out what are the dimension for each of my business processes. I need your advise on how to establish some of my dimensions. I'll try to explain the layout of my data as best as possible. Below is a hopefully clear layout of 4 tables in my database. The business requirement and business process that I'm identifying here are "report employee location aquisition" and "Location Adquisition" respectively. An employee can adquire one or more LandLocations which can reside on one or more counties. How can I define dimension for my bus matrix here? It seems that I have three dimensions Employee, LandLocation and County but I'm repeating again my database structure isn't? Any guiadance would be very appreciated.
tbl_Employee
EmployeeID
one to many
tbl_EmployeeBuysLandLocation
EmployeeID
LandLocationID
many to one
tbl_LandLocation
LandLocationID
Field1
Field2
Field3
one
to
many
tbl_LandLocationCounty
LandLocationID
CountyID
Size
many
to
one
tlb_County
CountID
tbl_Employee
EmployeeID
one to many
tbl_EmployeeBuysLandLocation
EmployeeID
LandLocationID
many to one
tbl_LandLocation
LandLocationID
Field1
Field2
Field3
one
to
many
tbl_LandLocationCounty
LandLocationID
CountyID
Size
many
to
one
tlb_County
CountID
hespinoza- Posts : 5
Join date : 2013-02-19
Location : Midland, TX
Similar topics
» Question about Dimensions with SKeys to join with other dimensions.
» Question on joining dimensions to avoid possible snowflake
» One Question
» Correlated - Separate Dimensions OR Single Dimensions ?
» Design all dimensions as conformed dimensions
» Question on joining dimensions to avoid possible snowflake
» One Question
» Correlated - Separate Dimensions OR Single Dimensions ?
» Design all dimensions as conformed dimensions
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|