Dimension Tables
Dimension Table:
Dimension table is one that describe the business entities of an enterprise, represented as hierarchical, categorical information such as time, departments, locations, and products. Dimension tables are sometimes called lookup or reference tables.
Location Dimension:
In a relational data modeling, for normalization purposes, country lookup, state lookup, county lookup, and city lookups are not merged as a single table. In a dimensional data modeling(star schema), these tables would be merged as a single table called LOCATION DIMENSION for performance and slicing data requirements. This location dimension helps to compare the sales in one region with another region. We may see good sales profit in one region and loss in another region. If it is a loss, the reasons for that may be a new competitor in that area, or failure of our marketing strategy etc.
Example of Location Dimension:
Country Lookup:
[ultimatetables 27 /]
State Lookup:
[ultimatetables 28 /]
County Lookup:
[ultimatetables 29 /]
City Lookup:
[ultimatetables 30 /]
Location Dimension:
[ultimatetables 31 /]