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…