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:

Example of Location Dimension

 

Country Lookup:

[ultimatetables 27 /]

State Lookup:

[ultimatetables 28 /]

County Lookup:

[ultimatetables 29 /]

City Lookup:

[ultimatetables 30 /]

Location Dimension:

[ultimatetables 31 /]

 

Next⇒ Product Dimension

(Visited 15,812 times, 2 visits today)

Leave a Reply

Your email address will not be published. Required fields are marked *