Static Dimension

A static dimension refers to a dimension table in a data warehouse that does not change or infrequently changes over time.

Values Never Change.

Time Dimension: Days, weeks, months

Payment Method Dimension: Credit Card, Debit Card, PayPal, Zelle, etc.

Education Level Dimension: High School, Bachelor, Master, PhD, etc.

Geographic Dimension: Store Locations, Categories, US States, Countries, etc.